regarding select into - Mailing list pgsql-general

From surabhi.ahuja
Subject regarding select into
Date
Msg-id 967CFC4343BF2A4DAFACD026D33DC85118EC70@jal.iiitb.ac.in
Whole thread Raw
Responses Re: regarding select into
List pgsql-general
 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

pgsql-general by date:

Previous
From: CSN
Date:
Subject: Re: Function keys cause psql to segfault
Next
From: Csaba Nagy
Date:
Subject: Re: Slow connection to the database