[GENERAL] -devel files

2012-01-15 Thread Graeme Gemmill
I intend to compile Postgresql 9.1.2 for my particular machine and also need the -devel files. I can't see any reference to them in the download libraries. Could sone kind soul tell me where they are please? Thanks -- Grimble Registered Linux User #450547 Running KDE 4.6.5 on

Re: [GENERAL] how to make select for multiunit

2012-01-15 Thread Misa Simic
Hi, I have understood he does not want to round... I would make custom type myUofM KRT int, PAK int, PCS int Then function to_myUofM which has 1 input parametar as int, and returns myUofM, (imutable func) so SELECT to_myUofM(25) returns 0,2,5 25 PCS is 0 KRT, 2 PAK and 5 PCS Then query:

Re: [GENERAL] -devel files

2012-01-15 Thread Adrian Klaver
On Sunday, January 15, 2012 8:17:19 am Graeme Gemmill wrote: I intend to compile Postgresql 9.1.2 for my particular machine and also need the -devel files. I can't see any reference to them in the download libraries. Could sone kind soul tell me where they are please? Are you downloading the

[GENERAL] HELP, how to make this query.

2012-01-15 Thread plasmasoftware net
*select j.kode_barang kode_barang,j.isi_Satuan from J_master_barang j **order by j.kode_barang asc* *display * kode isi 01 24 01B 12 01C 1 i want to make that become when i select my table.how to make this. kode isi_A

Re: [GENERAL] HELP, how to make this query.

2012-01-15 Thread Raghavendra
On Sun, Jan 15, 2012 at 12:17 PM, plasmasoftware net administra...@plasmasoftware.net wrote: *select j.kode_barang kode_barang,j.isi_Satuan from J_master_barang j **order by j.kode_barang asc* *display * kode isi 01 24 01B 12 01C 1 i

Re: [GENERAL] How to return latest results without a polygon intersect?

2012-01-15 Thread David Waddy
Thank-you for the help. I defined the problem a little better and took your advice and asked in postgis users: http://www.postgis.org/pipermail/postgis-users/2012-January/032056.html Dave On Wed, Jan 11, 2012 at 11:20 PM, Andy Colson a...@squeakycode.net wrote: On 01/11/2012 07:14 PM, David

[GENERAL] Repercussions of Cancelled Autovacuum

2012-01-15 Thread Andrew Hannon
Hello, We have a large(ish) table that had a series of delete statements executed against it (culling most of the rows in the table). This triggered a time consuming autovacuum, which we allowed to run for 2+ days (and were planning to allow to run to completion). However, it ended up getting