write banks - Search results in mailing lists

2011-05-23 13:54:10 | problem with update data sets from front ends 8.4, Ubuntu 10.04 (Dean le Roux)

BANK" character varying(50), "BRANCH" character varying(50), "BRANCHCODE" character varying(50), "BKACCOUNTTYPE" character varying(50) DEFAULT 'Cheque'::character varying, "ACCOUNTNUMBER" character varying(50), "TYPETRANS" integer DEFAULT 0, "REMITTANCE" boolean, "RECEIPT" boolean, "JOURNAL" boolean, "VOUCHERREQ

2007-05-15 11:11:49 | Re: workday function (Gary Stainburn)

bank_holidays ---------------2007-01-012007-04-062007-04-092007-05-072007-05-282007-08-272007-12-252007-12-26 (8 rows) I've attached the code for anyone who want to use or improve

2005-05-31 14:55:25 | Assistance (Mariam Abacha)

write to seek your help in the context below. I am Mrs. Maryam Abacha the wife of the former Nigeria Head of state Late General Sani Abacha, whose sudden death occurred on 8th of June

2003-12-26 19:39:57 | Re: Anti log in PostgreSQL (Tom Lane)

writes: This is not a mathematical operation, it is a financial issue that has to conform to rules developed long ago by bankers

2003-06-02 09:43:09 | Re: SQL problem: bank account (Tom Lane)

"Erik G. Burrows" writes: If you don't mind a not-standard-SQL solution

2003-02-07 06:46:48 | Re: conversi ms-sql7 vs postgresql 7.3 (Richard Huxton)

Write a trigger to keep entries up to date as you insert/delete/update entries (basically, same as above but keeps things up to date) 3. Use a sub-query richardh=> SELECT * FROM bank

2002-10-28 09:57:20 | Re: Accumulated sums in SQL query (Marek Bartnikowski)

bank_account_movements containing two columns : > = : > > date and amount: : > > : > > date amount (in USD) : > > ------------------------------------- : > > 2002-10-01 20 : > > 2002-10-02 30 : > > 2002-10-03 -15 : > > 2002-10-04 -5 : > > 2002-10-05 -3 : > > 2002

2002-10-15 17:07:00 | Re: int id's helpful for indexing, or just use text names? (Tom Lane)

writes: Strings would be slower, but possibly not by enough to notice. The real question you should ask yourself is whether your text names are really good candidates to be primary keys. Are there ever

2002-04-11 02:31:52 | Re: Postgresql goes into recovery mode .... (Rajesh Kumar Mallah)

write it (untested): > update email_bank set userid = t_a.userid > where email

2001-08-05 21:30:11 | Re: Re: Data type confusion (Peter Eisentraut)

writes: Maybe. Or maybe not. Take 1 year and 3 seconds. E.g., '2001-08-06 03:03:03' - '1 year 3 seconds' = '2000-08-06 03:03:00' '2000

2001-07-17 19:42:19 | Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) (Josh Berkus)

write applications for the banking industry, which trades everything in flat files. Give Chris a break

2000-03-07 03:37:13 | Re: [SQL] insert default into serial fields? (Tom Lane)

Banks" writes: INSERT ... VALUES(..., DEFAULT, ...) ought to work according to SQL92, but we don't support

2000-02-27 23:29:57 | Re: [SQL] Problems with create table continued... (Tom Lane)

Banks" writes: NULL is not a valid column constraint according to SQL92. (Even

2000-02-27 02:48:43 | Re: [SQL] Default sequence values (Tom Lane)

Banks" writes: Try company_id int4 PRIMARY KEY DEFAULT nextval('company_id_seq'), Actually