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
>