Re: [GENERAL] postgresql how to duplicate rows in result.

2017-02-16 Thread Alessandro Baggi
Il 15/02/2017 19:11, Alessandro Baggi ha scritto: Il 14/02/2017 21:51, Merlin Moncure ha scritto: On Tue, Feb 14, 2017 at 12:36 PM, Merlin Moncure <mmonc...@gmail.com> wrote: On Tue, Feb 14, 2017 at 12:04 PM, Alessandro Baggi <alessandro.ba...@gmail.com> wrote: Hi list, sorry fo

Re: [GENERAL] postgresql how to duplicate rows in result.

2017-02-15 Thread Alessandro Baggi
Il 14/02/2017 21:51, Merlin Moncure ha scritto: On Tue, Feb 14, 2017 at 12:36 PM, Merlin Moncure <mmonc...@gmail.com> wrote: On Tue, Feb 14, 2017 at 12:04 PM, Alessandro Baggi <alessandro.ba...@gmail.com> wrote: Hi list, sorry for my english, I will try to example as well.

[GENERAL] postgresql how to duplicate rows in result.

2017-02-14 Thread Alessandro Baggi
Hi list, sorry for my english, I will try to example as well. I've a query that joins multiple tables and return a result like: id,customers,phone,code,number 1 , ,3,123 , 2 2 , aassdsds,33322,211 , 1 3 , ,21221,221 , 1 I need, where "number" field is > 1, to duplicate

Re: [GENERAL] [OT] Postgresql and PHP

2016-12-23 Thread Alessandro Baggi
Hi Adrian, And what is the count? Reported is 1 How do you know it fails? Really I don't know if it fails but $query = pg_query_params(); if(!$query) { echo pg_last_error($dbcon); echo "ERROR"; } else { $row = pg_fetch_assoc($query); if(!$row)

Re: [GENERAL] [OT] Postgresql and PHP

2016-12-23 Thread Alessandro Baggi
Il 23/12/2016 16:52, David G. Johnston ha scritto: On Fri, Dec 23, 2016 at 8:44 AM, Alessandro Baggi <alessandro.ba...@gmail.com <mailto:alessandro.ba...@gmail.com>>wrote: $query = pg_query_params($dbcon, "SELECT count(*) from bs_ipsource where srcaddr =

[GENERAL] [OT] Postgresql and PHP

2016-12-23 Thread Alessandro Baggi
Hi list, sorry for this OT. I have a table on postgresql like this: id serial not null, srcaddr varchar(16) not null I use this table to store ip address. I've used also inet type but changed to see if this solves my problem. From psql, I run: select count(*) from bs_ipsource where srcaddr