convert text to varchar

From: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>
To: "'pgsql-sql(at)hub(dot)org'" <pgsql-sql(at)hub(dot)org>
Subject: convert text to varchar
Date: 1999-05-03 15:33:14
Message-ID: 01BE9558.BC2A44E0.jt-kirkpatrick@mpsllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi! i have a text field (table ap3, field name apnote) that i would like
to insert into a varchar field (same field name, table name ap). any idea
why this doesn't work? insert into ap (apnote) select varchar('apnote')
from ap3; -- it fails with or without the single quotes.

TIA, jt

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Morton 1999-05-03 15:33:53 Re: [SQL] Slow Inserts Again
Previous Message Chris Bitmead 1999-05-03 15:02:32 Re: [SQL] No DIVIDE Operator