Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #4259: I don't understand this query

BUG #4259: I don't understand this query

From
"kannan"
Date:
The following bug has been logged online:

Bug reference:      4259
Logged by:          kannan
Email address:      kannan_siva70@yahoo.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]

Re: BUG #4259: I don't understand this query

From
Craig Ringer
Date:
kannan wrote:
> The following bug has been logged online:
>
> Bug reference:      4259
> Logged by:          kannan
> Email address:      kannan_siva70@yahoo.com
> PostgreSQL version: 2005

There is no version 2005 of PostgreSQL. Additionally, the query syntax
you have provided below looks like it'd only be understood by Microsoft
SQL Server.

I suspect you really meant to contact Microsoft SQL Server support, not
file a bug on PostgreSQL. Microsoft people often call Microsoft SQL
Server just "SQL" but in fact SQL is the command language understood by
many different database systems, not just MS SQL Server.

> Description:        I don't understand this query

That's not really a bug report. What happens when you run the query?
What did you expect to happen? If you get error messages, what is the
exact text of those error messages? What about the error messages do you
not understand?

In any case, I suspect you're better off asking this question in an MS
SQL Server forum. You might want to think about rewriting it in view of
the above questions so that when you do ask it in an appropriate place
somebody can understand it well enough to help you.

Note: I do not speak for the PostgreSQL team, I'm just a user trying to
help out.

--
Craig Ringer