> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Thursday, February 01, 2007 5:26 PM
> To: Hakan Kocaman
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Functions, composite types and Notice
>
>
> "Hakan Kocaman" <Hakan.Kocaman@digame.de> 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"*
