[pgpool-general: 2553] Re: Restrictions

[Jayadevan M]

Good to know that. Thank you.


On Mon, Feb 10, 2014 at 6:16 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> > Hitting space bar sent the mail before I completed it.Sorry.To continue
> -
> > Does this mean a query of type
> > "with myt as (select ..) select * from "
> > or it applies to only queries where we insert into one table and then
> using
> > RETURNING clause modify data in another table?
> > Regards,
> > Jayadevan
>
> "Multi statement query" means that a query consists of multiple
> queries separated by ";". For example,
>
> BEGIN;SELECT 1;SELECT 2;END
>
> WITH clause does not fall into the "multi statement query".
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140210/f037fec1/attachment.html>