[GENERAL] Make failure on v. 7.1.2

Can anyone see from the below sample of my make error what could be wrong??? First I would point out v. 7.0.3 is compiled and working fine on all machines.. I had one success and two failures for 7.1.2 on Make . The success on Cald

[GENERAL] Function Help

Hello all, I am working on a function to determine the date of the first saturday of the month. Currently I have: CREATE FUNCTION first_saturday(date) RETURNS date AS ' Select CASE WHEN date_part(\'dow\',\'$1\'::DATE)=0 THEN date(\'$1\')+6 WHEN date_part(\'dow\',\'$1\'::DATE)=1 THEN date(\'$1\

[GENERAL] Duplicate key errors and logging

Hello: Is there a way to tell Postgres to not log duplicate key errors? Many thanks, -- Arcady Genkin i=1; while 1, hilb(i); i=i+1; end ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unreg

Re: [GENERAL] [COMMITTERS] PostgreSQL on MAINFRAME

[Moved to general] > We are attempting to introduce LINUX/POSTGRESQL into our environment. > > We will test TURBOLINUX on the mainframe. Has anyone installed POSTGRESQL > on the MAINFRAME? I got an account on IBM/S390/Turbo Linux combo and happily ran PostgreSQL 7.1. -- Tatsuo Ishii

Re: [GENERAL] [HACKERS] Tupple statistics function

Bruce Momjian wrote: > > > Hi, > > > > I have written a small function that show how many tuples are dead > > etc. in a specified table. Example output is: > > > > test=# select pgstattuple('tellers'); > > NOTICE: physical length: 0.02MB live tuples: 200 (0.01MB, 58.59%) dead tuples: >100 (0.00

Re: [GENERAL] [HACKERS] Tupple statistics function

> "Thurstan" == Thurstan R McDougle <[EMAIL PROTECTED]> writes: Thurstan> In general EXPLAIN could be expanded to be a command to Thurstan> return an explanation and stats of many items. There could Thurstan> also be EXPLAIN that only shows fields and EXPLAIN VERBOSE Thurstan> that also show

Re: [GENERAL] Anyone get PHPGroupware running on RedHatLinux 7 ?

"jcd@sita" <[EMAIL PROTECTED]> wrote in message news:<9oo19s$2t3$[EMAIL PROTECTED]>... > Anyone get PHPGroupware running on RedHatLinux 7 w/ Postgresql ? I have it (v 0.9.9, IIRC) running on RH 7.1. Are you having problems getting it to work? ---(end of broadcast)

Re: [GENERAL] Function Help

Brian C. Doyle writes: > CREATE FUNCTION first_saturday(date) > RETURNS date > AS ' > Select CASE WHEN date_part(\'dow\',\'$1\'::DATE)=0 THEN date(\'$1\')+6 > WHEN date_part(\'dow\',\'$1\'::DATE)=1 THEN date(\'$1\')+5 > WHEN date_part(\'dow\',\'$1\'::DATE)=2 THEN date(\'$1\')+4 > WHEN date_part(\

Re: [GENERAL] [HACKERS] not on .hackers

August Zajonc: > I tend to follow the mailing list through news.postgresql.org, and it seems > like all the -hackers messages are ending up in the .general group rather > than .hackers. I also follow the mailing list(s) through news.postgresql.org and now that you mention it ... It hasn't alway

Re: [GENERAL] Function Help

That was it... I knew it was something simple.. Thanks Peter!!! At 11:06 PM 9/24/01 +0200, Peter Eisentraut wrote: >Brian C. Doyle writes: > > > CREATE FUNCTION first_saturday(date) > > RETURNS date > > AS ' > > Select CASE WHEN date_part(\'dow\',\'$1\'::DATE)=0 THEN date(\'$1\')+6 > > WHEN date

Re: [GENERAL] Function Help

> "Brian" == Brian C Doyle <[EMAIL PROTECTED]> writes: Brian> Hello all, Brian> I am working on a function to determine the date of the first saturday Brian> of the month. Brian> Currently I have: Brian> CREATE FUNCTION first_saturday(date) Brian> RETURNS date Brian> AS ' Brian> Select CASE

Re: [GENERAL] Function Help

The main reason is that I am not quering a table with it as of yet... Ultimately it will before query that is a Month do date query that does not use a calender month At 05:29 PM 9/24/01 -0700, Randal L. Schwartz wrote: > > "Brian" == Brian C Doyle <[EMAIL PROTECTED]> writes: > >Brian> Hell