From: Byron Nikolaidis <byronn@insightdist.com>
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
Cc: Paul Lisewski <paull@techone.com.au>
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Cc: Postgres Hackers List <hackers@postgreSQL.org>
Subject: Re: [HACKERS] Re: [INTERFACES] Re: ODBC driver
Date: Fri, 17 Apr 1998 10:40:34 -0400
Message-ID: <353769E2.D6F8A623@insightdist.com> (raw)
References: <5ABEF3A77B39D111970F0020AFA04D29AE1F@mailbox.techone.com.au>
<35367D36.18531358@insightdist.com>
<3536C22F.A1F0978C@alumni.caltech.edu>
Suggested mappings would be a big help.
Thanks,
Byron
Thomas G. Lockhart wrote:
> > > {fn UCase(...) ODBC function is not supported. Are you planning
> > > to support ODBC functions??
> > There are a ton of scalar functions that would need to be supported:
> > Strings: ascii, char, concat, difference, insert, lcase, left,
> > length, locate, ltrim, repeat, replace, right, rtrim, soundex, space,
> > substring, ucase
> >
> > Numerics: abs, acos, asin, atan, atan2, ceiling, cos, cot, degrees,
> > exp, floor, log, log10, mod, pi, power, radians, rand, round, sign,
> > sin, sqrt, tan, truncate
> >
> > Dates: curdate, curtime, dayname, dayofmonth, dayofweek, dayofyear,
> > hour, minute, month, monthname, now, quarter, second, timestampadd,
> > timestampdiff, week, year
> >
> > System Functions: database, ifnull, user
> >
> > And of course, the granddaddy of all functions, CONVERT().
> >
> > Now, some of the string functions like '{fn ucase()}' could fairly
> > easily be mapped to the Postgres "Upper" function. But what about all
> > the others?
> > Should they be implemented in the driver or in the backend? Or do we
> > just do the easy ones?
>
> Let's do both. Some already map to existing functions, which mean you
> get to do this in your driver I suppose. Others, like many of the math
> routines, should/could be in the backend.
>
> How do you want to organize attacking these? I can help now with
> suggesting mappings for existing functions (e.g. date_part('dow',
> datetime) gives you "dayofweek") and can help with new functions in a
> month or two. Or, perhaps others can help with that more quickly...
>
> - Tom
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, lockhart@alumni.caltech.edu, paull@techone.com.au, hackers@postgreSQL.org
Subject: Re: [HACKERS] Re: [INTERFACES] Re: ODBC driver
In-Reply-To: <353769E2.D6F8A623@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox