Re: Functions, composite types and Notice

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