Re: [SQL] Invoice number

Mike Castle wrote: > What do you do on the following scenario: > > Client 1 is placing an order, gets invoice #1. > Client 2 is simultaneously placing an order, and gets invoice #2. > > Client 1 changes mind and cancels order. Invoice #1 is not used. Invoice > #2 is. > > Client 3 comes along.

Re: [SQL] regcomp failed with error empty (sub)expression?

"Michael Miyabara-McCaskey" <[EMAIL PROTECTED]> writes: > regcomp failed with error empty (sub)expression > Anys thoughts as to what this means? I'd say it means the regexp code doesn't like your pattern. For example, I can trigger that with regression=# select 'abc' ~ '|33'; ERROR: regcomp fa

[SQL] regcomp failed with error empty (sub)expression?

Hello all, I just discovered the regex (regular expression matching in PGSQL 7.0.3... However, after trying to run my first query I got the following: regcomp failed with error empty (sub)expression Anys thoughts as to what this means? The following SQL statement generated the error. INSERT I

Re: [SQL] Invoice number

Mike Castle writes: > Client 3 comes along. Do they use invoice #1, out of order, or invoice > #3? It shouldn't matter, as long as every number is accounted for. Seems to me that a trigger could make a log entry every time the serial is incremented. Workable? > What happens in a paper world i

Re: [SQL] Invoice number

> What do you do on the following scenario: I don't enter ! > Client 1 is placing an order, gets invoice #1. Wrong! He gets an order number > Client 1 changes mind and cancels order. Invoice #1 is not used. Invoice > #2 is. > Client 3 comes along. Do they use invoice #1, out of order, or in

Re: [SQL] Invoice number

On Thu, Dec 21, 2000 at 05:50:43PM +, Oliver Elphick wrote: > Mike Castle wrote: > >On Thu, Dec 21, 2000 at 11:10:00AM +0100, Kaare Rasmussen wrote: > >> - Sequences are not rollback'able. > > > >Did you mean SERIAL instead of sequence here? > > > >If so, why is no rollbackable an

[SQL] pg_dump Error

Hi all, while trying to dump db shcema and content, I am getting the following error: [najm@localhost najm]$ pg_dump -D fliprdb > flipr.sql PQgetvalue: ERROR! tuple number 0 is out of range 0..-1 Segmentation fault (core dumped) Any suggestion what I am doing wrong and why i am

Re: [SQL] Create table doesn't work in plpgsql

Hi,there, I am not quite sure what you try to do. However, plpgsql allows you use any DDL, most of functions defined and sql operators. I don't see the problem. Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] w

Re: [SQL] Invoice number

Mike Castle wrote: >On Thu, Dec 21, 2000 at 11:10:00AM +0100, Kaare Rasmussen wrote: >> - Sequences are not rollback'able. > >Did you mean SERIAL instead of sequence here? > >If so, why is no rollbackable an issue? All you should need is unique >numbers. Not necessarily exactly seq

Re: [SQL] Invoice number

Mike Castle writes: > If so, why is no rollbackable an issue? All you should need is unique > numbers. Not necessarily exactly sequential numbers. Sometimes business rules require that every member of a sequence of such things as invoice numbers be accounted for. Speculation: Would it be possi

Re: [SQL] Create table doesn't work in plpgsql

On Thu, Dec 21, 2000 at 11:51:38AM +0100, Volker Paul wrote: > select famname || ', ' || givname from person where id=1234; > I know it's possible by building the select e.g. in bash > and calling psql with it as an argument, but do you see a possibility > that is closer to Postgres, e.g. in plpgs

Re: [SQL] Invoice number

Kaare, > How many times have I tried this > mailing list with no > success :-( Hey! It's a peer-to-peer mailing list. You want guarenteed answers, pay for support (I do) > I'm wondering how people creates guaranteed sequential > numbers - in my case > for invoice numbers. > > - Sequences

Re: [SQL] Invoice number

On Thu, Dec 21, 2000 at 11:10:00AM +0100, Kaare Rasmussen wrote: > - Sequences are not rollback'able. Did you mean SERIAL instead of sequence here? If so, why is no rollbackable an issue? All you should need is unique numbers. Not necessarily exactly sequential numbers. mrc -- Mike Ca

Re: [SQL] Invoice number

Hi, > I'm wondering how people creates guaranteed sequential numbers - in my case > for invoice numbers. See the PostgreSQL book p. 85 and 250, and the online doc about serials: CREATE TABLE person ( id SERIAL, name TEXT ); Volker Paul

Re: [SQL] Create table doesn't work in plpgsql

Hi, > I don't think you can use DDL(data definition language) in PL/SQL. > create table is not DML(data munipulation language) instead > it's a DDL. Thanks, but that leaves me with a problem. What I really want to do is something like select str from person where id=1234; where str is a string th

[SQL] Invoice number

Hi My, my. It works. How many times have I tried this mailing list with no success :-( I'm wondering how people creates guaranteed sequential numbers - in my case for invoice numbers. - Sequences are not rollback'able. - It seems overkill to have a table just for this. - What else? tia

[SQL] test

x -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse