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
a_table.value='something';

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.