Re: Quotes and spaces

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Oleg Lebedev <olebedev(at)waterford(dot)org>, Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: Marat Khairullin <xmm(at)rambler(dot)ru>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Quotes and spaces
Date: 2001-10-05 22:51:07
Message-ID: web-142849@davinci.ethosmedia.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Oleg,

I'm assuming that this is just a hypothetical example, as the below is
far from the fastest way to get something as simple as a name.

> BEGIN
> query := ''SELECT first_name || '''' '''' || last_name FROM
> user'';
> EXECUTE query;
> ...
> END;
> ...

I'm pretty sure your quotes are correct. However, I believe "query" is
a reserved word. Try using a different variable name.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

Attachment Content-Type Size
unknown_filename text/plain 2 bytes
unknown_filename text/plain 2 bytes
unknown_filename text/plain 2 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-10-05 23:31:27 Re: Quotes and spaces
Previous Message Oleg Lebedev 2001-10-05 22:28:26 Quotes and spaces

Browse pgsql-sql by date

  From Date Subject
Next Message Lee Harr 2001-10-05 23:01:29 Re: SQL CONSTRAINTS - Constraining time values from two attributes on
Previous Message Oleg Lebedev 2001-10-05 22:28:26 Quotes and spaces