Hi,
I don't have any idea how can I use postgres function to convert series of
number (currency) to my own string.
My string : F G H I J K L M N as the replacement for number : 1 2 3
4 5 6 7 8 9
Dozens = O
Hundreds = P
Thousands = C
Ten thousands = B
So.
200 = GP
2000
Thanks Sim, a very usefull information.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sim Zacks
Sent: Wednesday, May 07, 2014 7:33 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Crosstab function
What I have done in the
Hi Friends,
Could somebody help me with crosstab function ? I have warehouse table:
CREATE TABLE tblwarehouse (
id integer NOT NULL,
warehousename character varying(20)
);
COPY tblwarehouse (id, warehousename) FROM stdin;
2 OFFICE
3 STORE2
\.
And product
Hi David,
Are you sure that there is no pure sql solution for this ?
I think (with my very limited postgres knowledge), function can solve this.
So far i can use command:
select *
from crosstab
(
'select produkid, warehouseid, onhand
from tblproduct order by 1',
'select distinct
Very Clear instruction !
Thank you very much David. I will do it in my client app and follow your
guidance.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G Johnston
Sent: Tuesday, May 06, 2014 11:01 AM
To:
user add warehouse, crosstab column name will change automatically. And also
each row has total qty.
Please give detail command for this.
Thanks in advance !
-Original Message-
From: Joe Conway [mailto:m...@joeconway.com]
Sent: Wednesday, April 30, 2014 5:43 AM
To: Hengky Liwandouw
Hi,
I have read the instruction, change warehouseid to text, spend several hours
to test many option but it doesn't help.
This is the new query :
SELECT *
FROM crosstab(
'SELECT produkid, warehousename, onhand
FROM vwtest
ORDER BY 1,2')
AS ct (Produkid text, Store1
-Original Message-
From: Joe Conway [mailto:m...@joeconway.com]
Sent: Friday, April 25, 2014 10:23 PM
To: Hengky Liwandouw; 'pgsql-general General'
Subject: Re: [GENERAL] Return and sql tuple descriptions are incompatible
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/25/2014 12:19 AM
Hi,
I have the following crosstab command :
Select * from crosstab($$select produkid, warehouseid,onhand from vwtest
order by 1,2$$)
as t (produkid VARCHAR, warehouseid integer)
vwtest :
CREATE OR REPLACE VIEW public.vwtest (
produkid,
warehouseid,
onhand)
AS
Dear Kevin,
After reading the link you gave to me, changing shared_buffers to 25% (512MB)
of available RAM and effective_cache_size to 1500MB (about 75% of available
RAM) make the query runs very fast. Postgres only need 1.8 second to display
the result.
Thanks a lot !
On Nov 24, 2013, at
. This makes me headache :D
Postgre really fast, has excellent feature, clear documentation, has great
community and really so many plus point.
Thanks you all.
On Nov 18, 2013, at 4:47 PM, Raymond O'Donnell wrote:
On 18/11/2013 02:16, Hengky Liwandouw wrote:
Dear Friends,
Please help
0 END) AS out_sum
FROM c
GROUP BY product_id
) c USING (product_id)
WHERE a.supplier_id='XXX';
Cheers,
Ken
On Mon, Nov 18, 2013 at 12:47 AM, Raymond O'Donnell r...@iol.ie wrote:
On 18/11/2013 02:16, Hengky Liwandouw wrote:
Dear Friends,
Please help for the select
Dear Friends,
Please help for the select command, as i had tried many times and always can
not display the result as what i want.
I am looking for the solution on google but still can not found the right
answer to solve the problem.
I have 3 tables :
Table A
ProductID
Dear David,
Thanks for your reply.
Table A is product table contains ProductID, Name, Supplierid etc.
Table B is initial stock contains ProductID, Qty
Table C is the transaction table contains ProductID, date, in, out, remarks, etc
As i use trigger to write to a log file for any INSERT, UPDATE
Dear Friends,
Please help for the select command, as i had tried many times and always can
not display the result as what i want.
I am looking for the solution on google but still can not found the right
answer to solve the problem.
I have 3 tables :
Table A
ProductID
Dear all,
I have another problem with Access 2003 as front end with Postgre 8.1, ODBC
version 8.02.02 Unicode.
I just upgrade the Point of Sales Program to Access 2003 MDE, all station
running XP Home wth Access 2003 on P4 3.0, 512MB Memory, 40GB HDD. Server run
Windows Server 2003
Dear all,
I have a very strange problem with Access 2003 as frontend and PqSql 8.1 as
backend.
In my access application, i have order form with orderdetail subform.
Subform recordsource, based on a saved Access query that has very simple
calculated field AMOUNT that calculate
17 matches
Mail list logo
