regarding select into

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: regarding select into
Date: 2005-09-26 07:36:51
Message-ID: 967CFC4343BF2A4DAFACD026D33DC85118EC70@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2005-09-26 08:15:38 Re: Slow connection to the database
Previous Message CSN 2005-09-26 03:41:46 Re: Function keys cause psql to segfault