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

2017-06-07 Thread Jan de Visser
On Tuesday, June 6, 2017 10:32:16 PM EDT Patrick B wrote: > 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. > > Examp

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

2017-06-06 Thread David G. Johnston
On Tuesday, June 6, 2017, Patrick B wrote: > > I have the type/string value stored in another table, and from that i > would like to get the id. > JOIN ON (expression) ? David J.

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

2017-06-06 Thread Patrick B
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. Example: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=15c571caa36876f00a0a2eaace70