No Subject

1998-07-23 Thread Postgres
Hi all How can i put limited length varchar(20) to SQL function? I have: create table bb ( c varchar(20), d int4 ); create function ins ( ???varchar???, int4) returns int4 as 'insert into bb (c, d) values ($1, $2); select 1; ' la

[GENERAL] datetime ?#!!??@

1998-07-23 Thread Davide Libenzi
I've successfully ported PostgreSQL to HPUX 9.0.* but there is a strange behaviour with the datetime data type. If do do this sequence : $ createdb mydb [OK] $ psqk mydb mydb==> create table foo (ffoo datetime); [OK] mydb==> insert into foo values ('01/01/1998'); [OK] mydb==> select ffoo fro

Re: [GENERAL] datetime ?#!!??@

1998-07-23 Thread Davide Libenzi
Pathc PHSS_4630 applied ! Everything OK Davide Libenzi at : Maticad s.r.l. Via Della Giustizia n.9 Fano (PS) 61032 Italy Tel.: +39-721-808308 (ra) Fax: +39-721-808309 Email: <[EMAIL PROTECTED]> WWW: -Original Message- From: Davide Libenzi <[EMAIL PROTECTED]

Re: [GENERAL] Re: [MIRRORS] Revamp'd Web Site...

1998-07-23 Thread Steve Doliov
Having spent about one year on revamping my own site, I am very appreciative of the efforts you made. However, I would suggest ditching frames if at all possible. If for no other reason than that frames make it virtually impossible for search egines to comprehesively index your site. The searc

[GENERAL] importing into postgres

1998-07-23 Thread Kevin Heflin
I'm using the IMPORT Table feature of pgaccess to import a .txt file. I've done this before and usually have no problems.. The table I'm importing into however has a field which I intended to be an auto numbering field.. INT DEFAULT nextval('team_id') and I have a sequence of team_id however wh

[GENERAL] Fwd: help with uniq index (fwd)

1998-07-23 Thread Lorenzo Huerta
can you all help me with this: > -- Forwarded message -- > Date: Thu, 23 Jul 1998 12:50:17 -0600 (MDT) > From: Lorenzo Huerta <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: help with uniq index > > > is there a way to create a unique index on