Skip site navigation (1) Skip section navigation (2)

char(19) to varchar(32)

From: Marc Tardif <admin(at)wtbwts(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: char(19) to varchar(32)
Date: 2000-01-18 14:04:48
Message-ID: Pine.BSF.4.10.10001181342200.7039-100000@server.b0x.com (view raw or flat)
Thread:
Lists: pgsql-sql
I have created a rule to update a char(19) field from a varchar(32) field.
I don't mind if half the field is cut out, I just want to copy the first
19 characters. Here's what I have
... update products set company=NEW.company;

company is char(19);
NEW.company is varchar(32);

Any suggestions on making this work?
Marc


Responses

pgsql-sql by date

Next:From: The Hermit HackerDate: 2000-01-18 17:20:08
Subject: Ordering a date_part() query ...
Previous:From: omid omoomiDate: 2000-01-18 10:48:22
Subject: Re: [SQL] Ordering a date_part() query ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group