Re: [GENERAL] status on IPv6 implementation...

1998-10-06 Thread Bruce Momjian
> > Hi all, > > > > I was just wondering if the IPv6 datatype has allready been > > implemented on the current version of postgres. > It should be in the CVS version, if you want to test it. > -DEJ Just a clarification. The new INET/MAC type in 6.4 will not have IPv6 capability, but is

[GENERAL] SQL Help

1998-10-06 Thread anil
Hello! I have a tabe : addates : (adid int 4,rundate date,posted boolean,dateid int4 unique create no. from sequence datesequence) table is like this adid rundate posteddateid 1031 05-17-199

Re: [GENERAL] Regex problems

1998-10-06 Thread chris yambo
If you want to select all the employes whose last name begins with a C you would use this regex '^C'. The ^ signifys the beginning of the string and you dont need a * after the C because a * means _zero_ or more matches, and that is the problem you were having chris yambo thoughtbubble productio

[GENERAL] Regex problems

1998-10-06 Thread Charles Curley
I'm running 6.3.2 on RedHat 5.0. I have the following table: Table    = employees +-+--+---+ |    Field    |  Type    | Length| +-+--+---+ | id  

Re: [GENERAL] make[2]: *** [psql] Error 1

1998-10-06 Thread Andrea Antibo
>|/usr/lib/libreadline.a(terminal.o): In function `_rl_enable_meta_key': >|terminal.o(.text+0x7ce): undefined reference to `tputs' >|/usr/lib/libreadline.a(terminal.o): In function `_rl_control_keypad': >|terminal.o(.text+0x7fb): undefined reference to `tputs' >|terminal.o(.text+0x822): undefine

RE: [GENERAL] status on IPv6 implementation...

1998-10-06 Thread Jackson, DeJuan
> Hi all, > > I was just wondering if the IPv6 datatype has allready been > implemented on the current version of postgres. It should be in the CVS version, if you want to test it. -DEJ > Thanks, > Lorenzo Huerta > > > > _ > D

RE: [GENERAL] Still the problem with the autoincrement field

1998-10-06 Thread Greg Youngblood
Try: insert into offene_stellen (bezeichnung,arbeitsort,berater,gefordert,geboten) values ('Maurer', 'Buchs', 'Rheinhalter Claudio', 'flexibilitaet', 'gutes Team'); Gregory S. Youngblood ext 2164     -Original Message- From: Marc Eggenberger [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

[GENERAL] Performance

1998-10-06 Thread G
Hi, I currently us miniSql and have had problems with performance on a large database. as an example I have a 30mg+ simple database each entry is date stamped. When I request 1 years worth of data it take forever to return and most of the time the browser times out. but when I request the data th

[GENERAL] using datetime from C

1998-10-06 Thread Memphisto
Hi, How can I use the datetime type from C (embedded SQL)? I also would like to know where can I find example ebmedded SQL source for postgreSQL. Thanks in advance Sebestyén Zoltán

Re: [GENERAL] make[2]: *** [psql] Error 1

1998-10-06 Thread James Oden
-Original Message- From: Andrea Antibo <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Date: Monday, October 05, 1998 14:25 Subject: [GENERAL] make[2]: *** [psql] Error 1 |when I compile postgres 6.3.2 under linux I have this error with "make all" and |"make install": |

Re: [GENERAL] Still the problem with the autoincrement field

1998-10-06 Thread Kevin Heflin
On Tue, 6 Oct 1998, Marc Eggenberger wrote: > > and when I want to add some data .. how to do this? > when I do the following: > > insert into offene_stellen values ('', 'Maurer', 'Buchs', 'Rheinhalter Claudio', >'flexibilitaet', 'gutes Team'); > > the id field is always 0, and when I do a: >

[GENERAL] Still the problem with the autoincrement field

1998-10-06 Thread Marc Eggenberger
Hi there. As two people said I created now a sequence I have the following now: Database= jobforum +--+--+--+ | Owner | Relation | Type | +--+---

Re: [GENERAL] How to have a autoincrement field?

1998-10-06 Thread Kevin Heflin
On Tue, 6 Oct 1998, Marc Eggenberger wrote: > With the current database I need a field that is automaticly > incremented when data is added. I looked in the docs, and the > mailinglist archive ... could find any suitable ... I suppose there may be an easier/better way than this. But what I do wh

[GENERAL] How to have a autoincrement field?

1998-10-06 Thread Marc Eggenberger
Hi there. I'm making my first steps on postgreSQL on a Sun Solaris. With the current database I need a field that is automaticly incremented when data is added. I looked in the docs, and the mailinglist archive ... could find any suitable ... Can someone help? -- mit freundlichen Gruessen ==

Re: [GENERAL] status on IPv6 implementation...

1998-10-06 Thread Tom Ivar Helbekkmo
Lorenzo Huerta <[EMAIL PROTECTED]> writes: > I was just wondering if the IPv6 datatype has allready been > implemented on the current version of postgres. IPV4 will be in 6.4, but IPV6 won't. I've left comments and hooks all over the IPV4 implementation, marking where to extend it to support