Skip site navigation (1) Skip section navigation (2)

BUG #4259: I don't understand this query

From: "kannan" <kannan_siva70(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4259: I don't understand this query
Date: 2008-06-23 05:07:27
Message-ID: 200806230507.m5N57Rth013499@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4259
Logged by:          kannan
Email address:      kannan_siva70(at)yahoo(dot)com
PostgreSQL version: 2005
Operating system:   Windows 2003 Server
Description:        I don't understand this query
Details: 

create table [dbo].[olapobjects] (
			[id] [varchar] (36) collate sql_latin1_Genenral_Cp1_Ci_As not null,
			[parent id] [varchar] (36) collate sql_latin1_genenral_cp1_ci_As not
null,
			[objectname] [varchar] (150) collate sql_latin1_genenral_cp1_ci_As not
null,
			[classtype] [int] not null,
			[object definition] [ntext] collate sql_latin1_genenral_cp1_ci_As null,
			[lastupdated] [datetime] null,
			[changed] [bit] nill,
			[version] [int] null
) on [primary] textimage_on [primary]

Go

create Table [dbo].[server] (
			[objectdefinition] [ntext] collate sql_latin1_genenral_cp1_ci_As null,
) on [primary] textimage_on [primary]

Responses

pgsql-bugs by date

Next:From: Craig RingerDate: 2008-06-23 08:27:15
Subject: Re: BUG #4259: I don't understand this query
Previous:From: Bill ThoenDate: 2008-06-22 23:39:38
Subject: Re: Abnormal termination of PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group