SELECT INTO behavior in SQL functions

From: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SELECT INTO behavior in SQL functions
Date: 2002-03-07 22:00:10
Message-ID: 3C87E2EA.4070208@mmrd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Do PostgreSQL SQL functions have any behavior similar to SQL92 SELECT
INTO so that I can have variables to use later in the function? This
function deletes one or more rows and updates the rest of the rows in
the table, but the updates require some of the data from the deleted
rows. I was going to try SELECT foo, bar INTO myfoo, mybar .... until I
noticed in the docs that PostgreSQL overrides this behavior. Does it
provide any alternates, or do I need to just go ahead and write a
plpgsql function instead?

-Fran

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Grannis 2002-03-07 22:06:27 Advice for optimizing queries using Large Tables
Previous Message Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= 2002-03-07 21:30:29 Re: Installing 7.2 on RedHat 7.1