On Wed, 17 Jun 1998 [EMAIL PROTECTED] wrote:
> Is there any way of having an apostrophe in a data field?
> It is a problem because the apostrophe is the same character as the single
> quote, so the database gets a parser error when a name such as "O'Brian"
> is entered.
>
> There must be a work
Hi all,
I'm looking for a function like COALESCE() or the Oracle NVL(),
to returns a ZERO value instead of a NULL value.
To have the result: NULL+1 = 1 instead of NULL+1 = NULL
Have PostgreSQL something like this ?
I tried to write it on C but I can't realize the beavior of NULLs,
I can't get tha
On Tue, 9 Jun 1998, Mehrdad Ghassempoory wrote:
> I am trying to set up the table separator (Default "|") to TAB
> caharcter.
>
> I have tried :
>
> \f\t
> \f \t
> \f '\t'
>
> Without any luck.
> How is it done?
Try psql -F""
this mean ^I
Jose'
On Mon, 8 Jun 1998, ENTER YOU NAME HERE wrote:
> Hi all
> I am using PostgreSQL as part of my MSc project. Because it is an
> object-relational database it is a superset of a pure relational and so
> tried to add foreign keys but are not supported. How can I overcome this
> problem?
man create_tr
On Mon, 8 Jun 1998, Fredrick Meunier wrote:
> Hi,
> I have a database design tool under windows, and it has a
> feature where you can store varoius metadata about your database
> in an ODBC database. I would like to use PostgreSQL as the
> repository. The product goes and creates it's own
Hi, all!
I am trying to create a trigger to update a field on a "son" table
when a linked field (foreign key) is modified on a table "father".
example:
table son: table father:
-
id /-< id
description
On Wed, 3 Jun 1998, Constantin Teodorescu wrote:
> Jose' Soares Da Silva wrote:
> >
> > pgtcl.c:20: tcl.h: No such file or directory
>
> I really do not understand why it wouldn't compile the 6.3.2!
> Be aware ! 6.3.2 has a little error in ./configure determin
On Mon, 25 May 1998, Marin D wrote:
Do you want revoke all previleges from postgres?
Remember that user postgres is the super user.
I think you don't do that.
Jose'
>
> Hi!
>
> I cant make grant/revoke work...
>
> An example
>
> test=> \z
> ...
>
On Sun, 24 May 1998, The Hermit Hacker wrote:
> That command did not return an error, rather it said CHANGE (without
> the exclamation marks, of course). However, afterward, I was still able
> to insert into the table. What gives?
It works for me, I have v6.3
>
> Also, another question:
>
Hi all,
I see that PostgreSQL mainly gives error messages in English, I see also that
in some cases there's the possibility to configure it to give messages in
other languages like global.c that may be configured to give messages in
German.
MySQL gives the possibility to configure it using an ex
On Tue, 19 May 1998, Kevin Heflin wrote:
> On Tue, 19 May 1998, Jose' Soares Da Silva wrote:
>
> > If you use "datetime" type instead of "date" and set datestyle = 'Postgres'
> > your data will be like: Sat Dec 12 00:00:00 1998 CET
> >
On Mon, 18 May 1998, Kevin Heflin wrote:
> Any hints or clues on this one?
> Using Postgresql6.3 and PHP2
>
> I have a simple database with a list of events, one of the fields is of
> the data type "date".
>
> When I call this information from the database, it prints out the date
> in the form
12 matches
Mail list logo
