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 probably
unique, you could as well do: select ser, 1 from tab1 where id=$1;
Otherwise, whatever interface you're using is likely to have a rowcount
value for you.
If that's not what you're looking for, please don't make us guess what
you want to achieve.
--
Alban Hertroys
alban@xxxxxxxxxxxxxxxxx
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
//Showing your Vision to the World//
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
