> -----Original Message----- > From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] > Sent: Thursday, February 01, 2007 5:26 PM > To: Hakan Kocaman > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] Functions, composite types and Notice > > > "Hakan Kocaman" <Hakan.Kocaman@xxxxxxxxx> writes: > > If you want to get the OUT-Params each as columns, you got > to call it > > this way: > > =# select (public.check_notice(2,'hello')).*; > > Try this way instead: > > select * from public.check_notice(2,'hello'); > > regards, tom lane > Thanks Tom, i'm a little bit ashamed :~) Perhaps i can excuse my blindness with the fact, that i want to feed the function with 3 params, that i gather from 2 tables. so i call the function now like this (obfuscated): select public.check_notice(t1.a,t1.b,t2.c) from public.tab1 t1, public.tab2 t2 I'm not clear how i can use the mentioned syntax with this kind of query. I can't put the function and the tables on the same level(FROM-Clause), is their any other way? Thanks a lot Hakan *goes buying "SQL for dummies"*
