pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
using plpgsql outside of functions
2+ messages / 2 participants
[nested] [flat]

* using plpgsql outside of functions
@ 2003-09-24 15:22 Miklos Keresztes <keresztes_m@yahoo.com>
  2003-09-24 15:42 ` Re: using plpgsql outside of functions Richard Huxton <dev@archonet.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Miklos Keresztes @ 2003-09-24 15:22 UTC (permalink / raw)
  To: pgsql-sql

Hello,
Is any way to use the plpgsql outside of functions? I
want to create a SQL script file using plpgsql for use
with pgAdmin query window.

Thanks,
    Kerv


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: using plpgsql outside of functions
  2003-09-24 15:22 using plpgsql outside of functions Miklos Keresztes <keresztes_m@yahoo.com>
@ 2003-09-24 15:42 ` Richard Huxton <dev@archonet.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2003-09-24 15:42 UTC (permalink / raw)
  To: Miklos Keresztes <keresztes_m@yahoo.com>; pgsql-sql

On Wednesday 24 September 2003 16:22, Miklos Keresztes wrote:
> Hello,
> Is any way to use the plpgsql outside of functions? I
> want to create a SQL script file using plpgsql for use
> with pgAdmin query window.

No - plpgsql will only be parsed as the body of a function. You can always 
create the function, call it, then drop the function.
-- 
  Richard Huxton
  Archonet Ltd



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-09-24 15:42 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-24 15:22 using plpgsql outside of functions Miklos Keresztes <keresztes_m@yahoo.com>
2003-09-24 15:42 ` Richard Huxton <dev@archonet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox