Re: Can I insert two different variables from form into different tables using one SQL query ? - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: Can I insert two different variables from form into different tables using one SQL query ?
Date
Msg-id 021501c13d4f$0b4ed130$279c10ac@INTERNAL
Whole thread Raw
In response to Can I insert two different variables from form into different tables using one SQL query ?  ("Sapenov" <sapenov@timscanada.com>)
List pgsql-general
Yes, if you use a custom function: no, if you just want to use SQL.
You can wrap as many insert statements as you like into a pl/pgsql function,
using values passed in as arguments to your function.
Hard to see the point of doing this, though.  Surely harder to maintain than
actual SQL.

"Sapenov" <sapenov@timscanada.com> wrote in message
news:5ZSn7.22167$BS1.2402844@news20.bellglobal.com...
> Can I insert two different variables from form into different tables using
> one SQL query ?
>
>
>
>
> --
> Regards,
>
> Sapenov Khazretgali
> System Engineer
> CMS
> 20 Eglinton Ave West
> Toronto, ON   M4R 1K8
> sapenov@cmsrecruit.com
> tel. 416 487-0290
> fax. 416 487-5771
> toll free :1-888-244-1340
>



pgsql-general by date:

Previous
From: "Krog, Kenneth"
Date:
Subject: Working with dates and queries
Next
From: "Oliver Elphick"
Date:
Subject: Re: query help