The below is what I'd like: select * from table natural join (select tablename from table where table_id = 'rid'); select tablename from table where table_id = 'rid'; returns 'table2' So, the equivalent of what I'd like in this case is: select * from table natural join table2; I could do this with a plpgsql function using EXECUTE but returning the full result set will be troublesome for a while. Till then, 2 queries... -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened.
BEGIN:VCARD VERSION:2.1 N:Taylor;Rod;B FN:Taylor, Rod B ORG:BarChord Entertainment Inc.;System Operation and Development TITLE:Chief Technical Officer ADR;WORK:;;;Toronto;Ontario;;Canada LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Toronto, Ontario=0D=0ACanada X-WAB-GENDER:2 URL: URL:http://www.barchord.com BDAY:19790401 EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;PREF;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] REV:20010219T170926Z END:VCARD