[ADMIN] FoxPro Vs. PostgreSQL
Hello all , I am a OpenSource S/W developer and my clients are from remote part of Himachal Pradesh India. I am providing my clients, software Build on PostgreSQL 7.3.x as backed and yes , they (clients) ought to save a lot while using my software as it runs on Linux But theirs one Prick Our Competitor he is providing solution in what else FoxPro + Win98 and this competitor justifies his software as Superior because some of the Indian local banks use this clumsy set of tool to manage their bureaucratic banking work system. What I want is some support from this good community to give me some 1. Tips 2. Links 3. Advise for FoxPro and its limits (As could be told to a layman) as how to crush my competitor for M$ tools, Its time to prove The M$ Guys that they have $ Power and we the GNU people have a social perspective of doing work. Would be greatefull for all your Comments / Bashing and yes Support Please.. To Add More : My Clients are Agriculture Banks and cannot afford the M$ tools. and yes all the Win98 installation on their computers are pirated. Regards, V Kashyap ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] Trigger function
Kent,
I suggest you read:
http://www.postgresql.org/docs/7.3/interactive/plpgsql-trigger.html
I found it very useful myself, and it should answer (almost?) all your
questions.
Note that you will need to add either pl/pgsql or pl/TCL to your
database to do triggers.
The docs. for both languages are at:
http://www.postgresql.org/docs/7.3/interactive/programmer-pl.html
Andrew
Kent L. Nasveschuk wrote:
Hello,
I'm trying to write a trigger that upon inserting a value in a table
another table is decremented. Something that could be used in an
inventory system, for example. I know it can be done easily outside
POSTGRES with PHP but in this case I would like the database to handle
it.
Example:
create table order (
order_number integer not null default
nextval('order_number_seq'::text),
itemid number integer references inventory,
item_amt integer,
cost numeric(3,2),
constraint order_pk primary key(order_number)
);
create table inventory (
itemid integer not null default nexval('itemid_seq'::text),
onhand integer not null default 0,
onorder integer not null default 0,
desc varchar(30) not null,
cost numeric(3,2) not null,
constraint inventory_pk primary key(itemid)
);
Can you give me some direction on how to do this. In this case decrement
the inventory by the amount of the order for that particular item. I'm
not sure how to pass variables to triggers and/or functions.
Thank you
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] [PERFORM] Tables Without OIDS and its effect
Neil Conway <[EMAIL PROTECTED]> writes: > BTW, we intend to phase out the use of OIDs for user tables in the > long term. I don't believe anyone has proposed removing the facility altogether. There's a big difference between making the default behavior be not to have OIDs and removing the ability to have OIDs. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
