On 2011-09-10, Gabriel Filipiak <gabriel.filip...@gmail.com> wrote: > --bcaec517adbceea3c804ac90a376 > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, this is my first on this list. > > I want to know the basics of dynamic sql especially in PostgreSQL. I was > googling for a while but have no luck for getting a good described examples. > Maybe someone here could give me some links to the materials from which you > where studying this subject.
Usually I go to the manual first. http://www.postgresql.org/docs/9.0/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN some things to consider: use quote_identifier and quote_literal when passing names and values into the sql statements: you can't pass variables in, only their values. -- ⚂⚃ 100% natural -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
