convert text to varchar - Mailing list pgsql-sql

From JT Kirkpatrick
Subject convert text to varchar
Date
Msg-id 01BE9558.BC2A44E0.jt-kirkpatrick@mpsllc.com
Whole thread
Responses Re: [SQL] convert text to varchar
List 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


pgsql-sql by date:

Previous
From: "Frank Morton"
Date:
Subject: Re: [SQL] Slow Inserts Again
Next
From: Michael J Davis
Date:
Subject: RE: [SQL] convert text to varchar