I concur with Jon. I'd use Character Varying. Dave
On Jan 10, 2007, at 5:31 PM, Jon Clausen wrote: > 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:266207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
