RE: [SQL] Distinct Values

2001-06-06 Thread KuroiNeko
> Author URL > --- > A http://www.xyz http://www.abc .com > - - > B http://www.def http://www.ijk http://www.rst .com > - - > > If that is what you want, you cannot manage it. Sure, in no way this is possible with SQL (in

Re: [SQL] binary operators

2001-02-02 Thread KuroiNeko
Frederic Metoz writes: > I am looking for the binary AND and OR ... SHIFT as well. > Do they exist for postgresql ? I have functions that do this on int4. Not operators, but better than nothing :) Anyone interested, please feel free to email in private. In fact, the lib is simple as a

Re: [SQL] Re: Requests for Development

2000-11-17 Thread KuroiNeko
> PL/pgSQL parses the entire function body at first call (per > backend). But the SPI querystrings for all the statements > aren't parsed at that time. It uses SPI_prepare() only for > expressions and queries that actually get executed, so that a > huge function that is called

Re: [SQL] Re: Requests for Development

2000-11-10 Thread KuroiNeko
> I wonder if there couldn't borrowed some code from Interbase which has > full featured stored procedures - at least it was told to me that it has > ... Well, I have some hands-on experience with IB, don't know whether this is perfectly relevant, but here goes Indeed, stored procedures

Re: [SQL] benchmarks

2000-10-28 Thread KuroiNeko
> Comparing PostgreSQL to MySQL is like comparing an 18-wheel Kenworth to > a Porsche. The two are not equivalent That's it. Major differences in features makes any benchmarking `apples to oranges.' > ... if you want a simple, very > very fast READ-ONLY database, use MySQL. BTW, can it be

Re: [SQL] benchmarks

2000-10-27 Thread KuroiNeko
> im just looking for independent benchmarks Even if there exist independent benchmarks, there are none being applicable to real life. > i personally love postgres > at work they like mysql > > currently we are investigating other possible db solutions Uh? You _love_ this and they

Re: [SQL] problem with select where like ']'

2000-10-17 Thread KuroiNeko
> hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > but i'm just wondering why like ']' doesn't work. > > What LOCALE setting are you running the postmaster in? > > ']' is not a special character as far as LIKE is concerned, but > I suspect you may be seeing another variant of the problems

[SQL] Formatting US phone numbers, was Variable-length Types

2000-10-16 Thread KuroiNeko
Josh and anyone interested, I've slightly changed the function. C source of a standalone program is available from http://www.primechoice.com/hum/uspn.c Comments welcome. Thx Ed PS Lemme know if you need a function, callable from PGSQL -- Well I tried to be meek And I have tr

Re: Antw: [SQL] many-many mapping between unique tables

2000-10-16 Thread KuroiNeko
> > I am facing a problem in mapping between two tables containing unique > > entries > > > Then you need a third table T12 with columns x and y, that contains one > row for each > mapping of a x(i) with a y(j). That's it. Normalize it. Relation T12 may also require the third field, `direct

Re: [SQL] Variable-length Types

2000-10-15 Thread KuroiNeko
Josh, > Thanks. You're probably right ... reformatting the phone numbers is > going to be a lot less work than a custom type. I remember from the old days of Delphi/InterBase, and even older days of Paradox, there were so called input masks, US phone code mask would be like (999)_000-00-00