[GENERAL] quote_literal

CREATE OR REPLACE FUNCTION "scheme"."function" (var varchar) RETURNS varchar AS DECLARE res varchar; BEGIN /* Which is correct? This: */ SELECT col1 FROM table WHERE col2=var INTO res; /*Or this:*/ SELECT col1 FROM table WHERE col2=quote_literal(var) INTO res; RETURN res; END; -- S

[GENERAL] sprintf

I need something like that SELECT sprintf('String with pattens: %d, %s',13,'abc'); and return: 'String with pattens: 13, abc'; Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Need More Case Studies on PostGIS

For exaple this http://www.postgresql.org/files/documentation/pdf/9.0/postgresql-9.0-US.pdf 20.12.2010, 04:05, "Wang, Mary Y" :Hi All,    I'd like to read more case studies on PostGIS.  I know some case studies are listed in http://postgis.refractions.net/ . Are there more case studies that you

[GENERAL] unable to write inside TEMP...

Hi. When installing PostrgeSQL (no mater 32 or 64-bit) on Windows Vista Home Premium (64-bit) i a get error message "Unable to write inside TEMP environment variable path." Any idea? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http