psql documentation one liner

Gavin Sherry wrote:

This just clears up one aspect of variable handling in psql.
[ "variable names are case-sensitive" ]

I honestly wonder why this is suddenly of so much interest. I hope no
one is going to question the fact that the command names are
case-sensitive. Do we need a note abou that, too?

Peter Eisentraut <peter_e@gmx.net> writes:

Gavin Sherry wrote:

This just clears up one aspect of variable handling in psql.
[ "variable names are case-sensitive" ]

I honestly wonder why this is suddenly of so much interest.

I think it's reasonable to document the behavior, especially seeing that
psql is at the intersection of traditionally-case-sensitive Unix and
traditionally-not-case-sensitive SQL. It is not instantly obvious which
behavior should be expected.

I take no position on whether this is the best way to document it...

regards, tom lane

On Tue, 10 Feb 2004, Peter Eisentraut wrote:

Gavin Sherry wrote:

This just clears up one aspect of variable handling in psql.
[ "variable names are case-sensitive" ]

I honestly wonder why this is suddenly of so much interest. I hope no
one is going to question the fact that the command names are
case-sensitive. Do we need a note abou that, too?

This arose because Neil and I were having a private conversation where
psql variables were involved. A script was not behaving correctly because
I assumed the variables were case insensitive. I'm not sure why -- perhaps
because SQL is case insensitive. I thought I'd send in the note so that no
one else could make the mistake.

Gavin

Peter Eisentraut wrote:

Gavin Sherry wrote:

This just clears up one aspect of variable handling in psql.
[ "variable names are case-sensitive" ]

I honestly wonder why this is suddenly of so much interest. I hope no
one is going to question the fact that the command names are
case-sensitive. Do we need a note abou that, too?

Patch applied. I just added a sentence, rather than an new paragraph.
I think the confusion is because SQL variable names aren't case
senstitive, so it is a little confusing.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073