470,614 Members | 1,396 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Creating variables outside a 'create function'

Is it possible to create variables outside a create statement? I'd
like to do something along the lines of

SELECT INTO temp primary_key_id from a_table where

However this seems to only work within creating functions. Probably
because it's being interpreted as standard sql instead of plpgsql.

This would probably mean the real question is can i ecapsulate a
sequence of sql statements with plpgsql?
Jul 19 '05 #1
0 1198

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

22 posts views Thread by Tom Moroow | last post: by
15 posts views Thread by Carlos Lozano | last post: by
9 posts views Thread by Patrick.O.Ige | last post: by
26 posts views Thread by optimistx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.