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

for psqlodbc developers: [ psqlodbc-Bugs-1000507 ] MSSQL syntax (fwd)

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: pgsql-odbc(at)postgresql(dot)org
Subject: for psqlodbc developers: [ psqlodbc-Bugs-1000507 ] MSSQL syntax (fwd)
Date: 2005-12-27 09:11:50
Message-ID: 20051227091149.GA741@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
I ask other developers: what's your opinion?

I know the man may need it but I don't think we want it. We
have to support Oracle, Informix, MySQL, ... special commands than.

I hope we don't need parse statements before execute them
in new development version so it could be slowdown in the future.

Regards,

Luf

> Summary: MSSQL syntax
> 
> Initial Comment:
> MSSQL have a command that Postgresql don't support:
> 
> @@spid
> 
> This command returns MSSQL connection pid.
> 
> I've a application that uses this query. I can't change code, but
> i need that psqlodbc ignore this command.
> 
> ----------------------------------------------------------------------
> 
> >Comment By: Ludek Finstrle (luf)
> Date: 2005-12-27 10:01
> 
> Message:
> I don't know if we want this behaviour. When you move to other DB
> do you think they will add support for this?
> 
> I need to talk about it with other developers. I'm againist this
> kind of support.
> 
> @@spid is whole command or is it located inside statements?
> 
> If you're a little bit familiar with C you can hack it into psqlodbc
> code yourself (I think in PGAPI_Prepare and PGAPI_ExecDirect).
> 
> ----------------------------------------------------------------------
> 
> Comment By: Nobody (None)
> Date: 2005-12-27 02:25
> 
> Message:
> can psqlodbc to transform all "@@xyz" syntax in:
> 
> xyz()
> 
> ?????

Responses

pgsql-odbc by date

Next:From: Dave PageDate: 2005-12-27 10:03:43
Subject: Re: for psqlodbc developers: [ psqlodbc-Bugs-1000507 ]
Previous:From: noreplyDate: 2005-12-27 09:01:10
Subject: [ psqlodbc-Bugs-1000507 ] MSSQL syntax

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