Problems with values in INSERT-Command

From: "Rudolph, Michael" <Michael(dot)Rudolph(at)telekom(dot)de>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Problems with values in INSERT-Command
Date: 1999-09-14 07:27:44
Message-ID: EB8366869DABD2119F3200A0C9F02CC8093FFB@u8p27
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

If I do the command

INSERT INTO TBL (f1) VALUES (2);
instead of
INSERT INTO TBL (f1) VALUES ('2');

I get an error-message "fmgr_info: function text: not in internal table".

According to the documentation, it must be possible, to put numeric values
without quotes, so what is the reason for the error. It happens in all other
cases, but sometimes even with worse error-messages. Any ideas?

Michael

Browse pgsql-sql by date

  From Date Subject
Next Message Jens Glaser 1999-09-14 08:00:57 reliable way to crash postgres :)
Previous Message Oleg Bartunov 1999-09-14 04:49:46 Re: [SQL] Postgres Table grows very quickly?