[GENERAL] Re: [HACKERS] Gregorian Calendar

1999-04-12 Thread Taral
On Mon, 12 Apr 1999, José Soares wrote: > $ cal 9 1752 The cal program has special hacks for that case. The date system doesn't know about the Gregorian Reform of dates. Taral

RE: [GENERAL] problem of upper/lower case in table names

1998-11-17 Thread Taral
t i'd > >like to know who's fault it is ( mine or postgres ) > >Thanks for your advices & help Try quoting the names... i.e. CREATE TABLE "TEST" etc. Taral

RE: [GENERAL] date null

1998-10-23 Thread Taral
use IS NOT NULL: SELECT * from prestito WHERE notifica1 IS NOT NULL OR notifica2 IS NOT NULL OR notifica3 IS NOT NULL; I seem to remember that the equality/inequality operators don't work on NULL right now... Taral > -Original Message- > From: [EMAIL PROTECTED] >

RE: [GENERAL] select and join

1998-10-23 Thread Taral
) FROM prestito, libro, utente WHERE libro.id_libro = prestito.id_libro AND utente.id_utente = prestito.id_utente GROUP BY cognome, id_utente, tipo; Taral

RE: [GENERAL] Making NULLs visible.

1998-10-09 Thread Taral
> Yes, \ always outputs as \\, excepts someone changed it last week, and I > am requesting a reversal. Do you like the \N if it is unique? Well, it's certainly clear, but could be confused with \n (newline). Can we have \0 instead? Taral

RE: [GENERAL] Making NULLs visible.

1998-10-09 Thread Taral
lows us to output control characters, etc., in a manner that is completely parsable. Taral