Postgres Pro
Downloads
Home   >   mailing lists

Re: (libpq) listen/notify messages are converted to lowercase and/or are case insensitive - Mailing list pgsql-general

From Tom Lane
Subject Re: (libpq) listen/notify messages are converted to lowercase and/or are case insensitive
Date
Msg-id 28828.1092596726@sss.pgh.pa.us
Whole thread Raw
In response to (libpq) listen/notify messages are converted to lowercase and/or are case insensitive  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
Responses Re: (libpq) listen/notify messages are converted to lowercase and/or are case insensitive  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
List pgsql-general
Tree view 
Frank van Vugt <ftm.van.vugt@foxi.nl> writes:
> Obviously, things work and they probably work as intended, but I wasn't able
> to find anything on this behaviour in the docs. For a moment I thought that
> the syntax rule 'unquoted letters are forced to lowercase' of SQL applied
> here as well, but any double quotes used are simply interpreted as part of
> the name.

You had the right idea: the arguments of listen and notify commands are
identifiers.  I don't know what convinced you otherwise.

regression=# listen "Z";
LISTEN
regression=# notify Z;
NOTIFY
regression=# notify "Z";
NOTIFY
Asynchronous notification "Z" received from server process with PID 28818.
regression=# listen z;
LISTEN
regression=# notify "Z";
NOTIFY
Asynchronous notification "Z" received from server process with PID 28818.
regression=# notify Z;
NOTIFY
Asynchronous notification "z" received from server process with PID 28818.
regression=#

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: table functions as fields in a select
Next
From: Robby Russell
Date:
Subject: Re: PHP Postgre-MySql call redirector