X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 77258D1B4F6 for ; Wed, 8 Oct 2003 13:51:24 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 59985-05 for ; Wed, 8 Oct 2003 10:50:42 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id A4A80D1B587 for ; Wed, 8 Oct 2003 10:50:38 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h98DocQh052547 for ; Wed, 8 Oct 2003 13:50:38 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h98DiwCa051361 for pgsql-sql@postgresql.org; Wed, 8 Oct 2003 13:44:58 GMT From: "Bill Pfeiffer" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: PG equivalent to Sybase varbinary Date: Wed, 8 Oct 2003 09:44:18 -0400 Organization: Hub.Org Networking Services Lines: 29 Message-ID: References: <200310080945.06497.dev@archonet.com> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/149 X-Sequence-Number: 15549 Thanks for the response. I'll look into re-running the ddl using the bytea datatype the next time I perform the setup I'm using. (I used a Sybase SQL Anywhere db in the meantime to get me back on track with the task at hand). Thanks again, Bill "Richard Huxton" wrote in message news:200310080945.06497.dev@archonet.com... > On Monday 06 October 2003 15:40, Bill Pfeiffer wrote: > > Anybody know what the Postgresql equivalent to a Sybase varbinary data type > > is? I have a package that provides ddl to store a 40 byte/char? varbinary > > column in a table and it is failing against postrgresql. > > Sounds like "bytea" to me - or have you rejected that? > > -- > Richard Huxton > Archonet Ltd > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >