RE: psql problem

From: Volker Paul <vpaul(at)dohle(dot)com>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: RE: psql problem
Date: 2000-06-02 07:10:36
Message-ID: 01BFCC72.6AF96310@wpaul.dohle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Does anyone know why when I am in a particular DB as user postgres and use
the following statement, why I get this error?"

This is the statement;
SELECT * FROM some_file where ID = 1;

[Volker Paul] If your ID field is really uppercase, try:
SELECT * FROM some_file where "ID" = 1;

Cheers,

Volker

Browse pgsql-sql by date

  From Date Subject
Next Message Adam Walczykiewicz 2000-06-02 09:47:33 pg_recvbuf : unexpected EOF on client
Previous Message Gerhard Dieringer 2000-06-02 07:02:12 Antw: Insert with replace?