From: | Brett McBride <brett(at)deakin(dot)edu(dot)au> |
---|---|
To: | Amit jain <amitjain(dot)bit(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: use of alias |
Date: | 2008-02-12 05:38:17 |
Message-ID: | 47B130C9.9000208@deakin.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
you could do this with 'execute' like so:
execute 'select count(*) into count1 from ' || MT || ',' || ST || '
where ' || MT || '.phonenumber= ' || ST || '.phonenumber' into v_variable;
brett
Amit jain wrote:
> Hello Everybody,
>
> I am trying to change a oracle function to postgreSQL. I have to use
> the function parameter in different query so i need to use alias command.
> but i am not able to use this alias in "from clause" of select
> statment. could anybody please let me know how can i use it in from
> clause.i am getting following error while executing the funciton..
>
> MT ALIAS FOR $1;
> ST ALIAS FOR $2;
>
> select count(*) into count1 from MT,ST where
> MT.phonenumber=ST.phonenumber;
>
> *ERROR: syntax error at or near "$1"
> LINE 1: select count(*) from $1 , $2 where MT.phonenumber=ST.phone...
>
> Thanx in Advance for all of your suggestion....*
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brendan Jurd | 2008-02-12 05:59:22 | Re: use of alias |
Previous Message | Amit jain | 2008-02-12 05:19:32 | use of alias |