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(at)timscanada(dot)com> wrote in message
news:5ZSn7(dot)22167$BS1(dot)2402844(at)news20(dot)bellglobal(dot)com(dot)(dot)(dot)
> 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(at)cmsrecruit(dot)com
> tel. 416 487-0290
> fax. 416 487-5771
> toll free :1-888-244-1340
>