[GENERAL] quote_literal

[tbazadaykin]

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; 

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] sprintf

[tbazadaykin]

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

[GENERAL] unable to write inside TEMP...

[tbazadaykin]

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://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Need More Case Studies on PostGIS

[tbazadaykin]

For exaple this http://www.postgresql.org/files/documentation/pdf/9.0/postgresql-9.0-US.pdf20.12.2010, 04:05, "Wang, Mary Y" mary.y.w...@boeing.com: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 can refer me to?  Thanks in  advance.  Mary