No you're right - now days. I've had some issues with older drivers where they would throw a syntax error on me so I always use character varying with Pg just to be on the safe side.
On Jan 10, 2007, at 6:10 PM, Matt Quackenbush wrote: > Sweet (regarding the single interface)! > > Jon, I was under the impression that varchar() was still a valid > datatype in > Postgre, and would not require changing to 'character varying'. > > http://www.postgresql.org/docs/8.2/static/datatype-character.html > > Am I mis-reading that? > > Dave, > > Thanks for the tips! > > > Thanks, > > Matt > > > On 1/10/07, Jon Clausen <[EMAIL PROTECTED]> wrote: > > > Some common datatype conversions for your adventure: :-) >> MSSQL | Postgres >> ---------------------------------------------------- >> IDENTITY(1,1) = serial >> varchar = character varying >> datetime = timestamp without time zone >> int = integer >> text = text >> >> If you migrate the data using DTS and then change the column types to >> serial later, you may need to run the following script on each table >> to establish the next sequence value for auto-incrementing (With your >> variables inserted for the table variables of course): >> >> SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('#table#', >> '#table_id#'), (SELECT max(#table_id#) FROM #table#), true); >> >> Good luck! >> >> Jon >> >> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
