[GENERAL] Extract from text id other table - PG 9.1

Поиск
Список
Период
Сортировка
От Patrick B
Тема [GENERAL] Extract from text id other table - PG 9.1
Дата
Msg-id CAJNY3iu27HeC+djtmvidYyTwUpnF46dz7iDKWzdooPbKyJYbbg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Extract from text id other table - PG 9.1
Re: [GENERAL] Extract from text id other table - PG 9.1
Список pgsql-general
Hi guys,

I've got tableA with 3 columns.

id(seriaL) | type(character varying(256)) | string(character varying(256))

I have the type/string value stored in another table, and from that i would like to get the id.


How can I extract, from that tablea.type_m column the tableb.id value?

Thanks
Patrick

В списке pgsql-general по дате отправления: