[EMAIL PROTECTED] ("surabhi.ahuja") wrote in
news:[EMAIL PROTECTED]:
> Hello,
>
> Is it not possible to write such an sql statement:
>
> select ser into val1, count(*) into val2 from tab1 where id = $1;
>
> do i need to perform the 2 selects separately ..wont that impact the
performance?
surabhi.ahuja wrote:
Hello,
Is it not possible to write such an sql statement:
select ser into val1, count(*) into val2 from tab1 where id = $1;
do i need to perform the 2 selects separately ..wont that impact the
performance?
Well, considering id is your primary key and therefore very
Hello,
Is it not possible to write such an sql
statement:
select ser into val1, count(*) into val2
from tab1 where id = $1;
do i need to perform the 2 selects separately
..wont that impact the performance?
in the table tab1, id is the primary
key.
Thank You
Regards
Surabhi Ahuja
