[GENERAL] parser

hi, got this question from a user, anyone up for some discussion on it 1) I have been using 6.3 and recently tried to move to 6.5. I found that the word "offset" is now a reserved word and I have used it as a field name in a table. 6.5 reports this as an error. I wonder if the parser should

[GENERAL] weird sum() results

I have a table with a filed named 'amount' and all the values are positive values, but if i do this: select sum(amount) from table where state = 'CA'; I get a negative number. Doing a select name, amount from table where state = 'CA' and amount < '0'; Returns 0 rows.

[GENERAL] Benchmarks for pgsql?

Hi: I'm looking for some benchmarks for pgsql, better if they use DBI/DBI, so we could compare psqql versus others DBMS. Is thete any on the net or someone working on it? Saludos, Roberto Andrade Fonseca [EMAIL PROTECTED]

Re: [GENERAL] Creating Triggers

Sarah Officer wrote: > > - A value must be returned if a return type is specified. The old & > new records are available as return values from the plpgsql > function. Unfortunately, OLD and NEW are only available in the function that's directly called by the trigger, not subsequent functions in

RE: [GENERAL] Problems with operator '%' within a select

Gabriel Fernandez wrote: [Snip] > I've just had some problems using the operator '%' within a select. > This is an example: > > "select codigo from codis where codigo like '%3'" > > And i've found that all the rows which contains more than one three > won't be selected. > (For example: values 'a

[GENERAL] Creating Triggers

Thanks to Ed Loehr and others on the group, I finally was able to create triggers in my database. This is a summary of what I learned in the process. For the most part, I didn't find this in the documentation. If anything here is incorrect, please let me know. If not, can it be put in document

Re: [GENERAL] jdbc question

From: [EMAIL PROTECTED] (Micheal H.) >Here's the code.It compiles but never gets past "Failed to load >postgresql driver" your classpath setting might be wrong, it must includes the jar filename as well, such as : CLASSPATH = /usr/local/lib/postgresql.jar you might also want to try : //S

[GENERAL] Unsigned Datatypes

Are there any plans to implement unsigned datatypes like uint4 and uint8? In many cases I don't need the signed int4 numbers, but I would be happy to have a larger range without using the twice as large int8 type. -- Martin Neumann, Welkenrather Str. 118c, 52074 Aachen, Germany [EMAIL PROTECTED

Re: [GENERAL] Trigger problem

Sarah Officer wrote: > > > delete from istatus where status_code = 'A1'; > ERROR: fmgr_info: function 18848: cache lookup failed > > What is the problem with the cache lookup? Any suggestions would be > appreciated. I seem to recall that kind of message often shows up when you have dropped an

[GENERAL] Trigger problem

I am trying to create a simple trigger function. With some help from the mailing list, I managed to create a trigger and functions. Unfortunately I get an error message when I delete from the table which has the trigger. Can anyone help me spot the error? Here's what I have done: CREATE FUNC

Re: [GENERAL] psql problem describing tables

Let me clarify. The reason there is not data in my table is because I haven't inserted any yet. I inserted a row of data. It gets selected correctly, but I still can't describe the table. So the problem doesn't seem to be related to having an empty table. Sarah Sarah Officer wrote: > > I am

[GENERAL] psql problem describing tables

I am running postgres 6.5.3 on an SGI. I haven't done much except create a few tables and indexes. When I enter psql and type '\d', all my tables and indexes are listed. When I type '\d tablename' however, I get the following message: \d Images ERROR: typeidTypeRelid: Invalid type - oid = 0

Re: [GENERAL] Re: [SQL] Bug in CEIL?

[Charset iso-8859-1 unsupported, filtering to ASCII...] > PostgreSQL 6.4.2 : > - > Welcome to the POSTGRESQL interactive sql monitor: > Please read the file COPYRIGHT for copyright terms of POSTGRESQL > >type \? for help on slash commands >type \q to quit >type \

[GENERAL] Problems with operator '%' within a select

Hi ! I've just had some problems using the operator '%' within a select. This is an example: "select codigo from codis where codigo like '%3' " And i've found that all the rows which contains more than one three won't be selected. (For example: values 'a34ree3', '34fg3') It seems as if you pu

[GENERAL] Re: [SQL] Bug in CEIL?

PostgreSQL 6.4.2 : - Welcome to the POSTGRESQL interactive sql monitor:  Please read the file COPYRIGHT for copyright terms of POSTGRESQL      type \? for help on slash commands   type \q to quit   type \g or terminate with semicolon to execute query You are currently conn

Re[2]: [GENERAL] Bug or my crooked hands?

Hello J., Once, Wednesday, January 19, 2000, 4:19:12 PM, you wrote: >> Hello All, >> >> I have the following situation: >> >> CREATE TABLE "Contacts" ( >> "Contact" Serial, >> "StuffTheir" Text, >> "TheDate" datetime DEFAULT TEXT 'now', >> "Subj" Text,

Re: [GENERAL] Bug or my crooked hands?

> Hello All, > > I have the following situation: > > CREATE TABLE "Contacts" ( > "Contact" Serial, > "StuffTheir" Text, > "TheDate" datetime DEFAULT TEXT 'now', > "Subj" Text, > "CustomerId" int4, > "Agent" int4, > "ActionType"

[GENERAL] Bug or my crooked hands?

Hello All, I have the following situation: CREATE TABLE "Contacts" ( "Contact" Serial, "StuffTheir" Text, "TheDate" datetime DEFAULT TEXT 'now', "Subj" Text, "CustomerId" int4, "Agent" int4, "ActionType" int2, "Done"