O Markus Schaber έγραψε στις Feb 22, 2006 :
> Achilleus Mantzios wrote:
> > In PgSQL 7.4.12,
> >
> > foodb=# SELECT '255.255.255.255/24'::cidr;
> > ERROR: invalid cidr value: "255.255.255.255/24"
> > DETAIL: Value has bits set to right of mask.
> > foodb=#
> >
> > SELECT '255.255.255.255/25':
Scott Marlowe wrote:
> On Wed, 2006-02-22 at 15:13, Andrew Sullivan wrote:
>
> > No, sorry. While we're at it, though, if you have the same field in
> > several tables, it's a good sign that your database is badly
> > normalised. You shouldn't have to update more than one table (which
> > is why
On Wed, 2006-02-22 at 15:13, Andrew Sullivan wrote:
> On Wed, Feb 22, 2006 at 11:59:06AM -0600, Judith Altamirano Figueroa wrote:
> > Hello everybody I need to update a field with the same value in the
> > tables of my data base but this field exists in almost all tables and
> > has the same va
On Wed, Feb 22, 2006 at 11:59:06AM -0600, Judith Altamirano Figueroa wrote:
> Hello everybody I need to update a field with the same value in the
> tables of my data base but this field exists in almost all tables and
> has the same value, I don't want to code a script, so my question is if
> t
Hello everybody I need to update a field with the same value in the tables of my data base but this field exists in almost all tables and has the same value, I don't want to code a script, so my question is if there is some way to update that field with a query and affects all the tables th
On Wed, 2006-02-22 at 12:08, Judith wrote:
>Hello everybody I need to update a field with the same value in the
> tables of my data base but this field exists in almost all tables and
> has the same value, I don't want to code a script, so my question is if
> there is some way to update that
Mario Splivalo <[EMAIL PROTECTED]> writes:
> Now, when I do this from one connection (psql shell, for instance):
> [A]BEGIN TRANSACTION;
> [A]SELECT * FROM bla WHERE code_id = 1 FOR UPDATE;
> and then, from another psql i do:
> [B]SELECT * FROM bla WHERE code_id = 1 FOR UPDATE
> the second SELEC
Am Mittwoch, 22. Februar 2006 19:08 schrieb Judith:
>Hello everybody I need to update a field with the same value in the
> tables of my data base but this field exists in almost all tables and
> has the same value, I don't want to code a script, so my question is if
> there is some way to updat
Hello everybody I need to update a field with the same value in the
tables of my data base but this field exists in almost all tables and
has the same value, I don't want to code a script, so my question is if
there is some way to update that field with a query and affects all the
tables that
I have a table, like this:
CREATE TABLE bla (id int4, code_id int4, code_value varchar, CONSTRAINT
bla_pk PRIMARY KEY (id))
And, i have index on the table:
CREATE INDEX bla_idx1 ON bla(code_id)
Now, when I do this from one connection (psql shell, for instance):
[A]BEGIN TRANSACTION;
[A]SELECT
O Peter Eisentraut έγραψε στις Feb 22, 2006 :
> Am Mittwoch, 22. Februar 2006 13:04 schrieb Achilleus Mantzios:
> > foodb=# SELECT '255.255.255.255/24'::cidr;
> > ERROR: invalid cidr value: "255.255.255.255/24"
> > DETAIL: Value has bits set to right of mask.
>
> > in this case
> > .111
Achilleus Mantzios wrote:
> In PgSQL 7.4.12,
>
> foodb=# SELECT '255.255.255.255/24'::cidr;
> ERROR: invalid cidr value: "255.255.255.255/24"
> DETAIL: Value has bits set to right of mask.
> foodb=#
>
> SELECT '255.255.255.255/25'::cidr;
> cidr
>
> 255.255.255.255
Hi, Peter,
Peter Eisentraut wrote:
> Am Mittwoch, 22. Februar 2006 13:04 schrieb Achilleus Mantzios:
>
>>foodb=# SELECT '255.255.255.255/24'::cidr;
>>ERROR: invalid cidr value: "255.255.255.255/24"
>>DETAIL: Value has bits set to right of mask.
>
>
>>in this case
>>...
Am Mittwoch, 22. Februar 2006 13:04 schrieb Achilleus Mantzios:
> foodb=# SELECT '255.255.255.255/24'::cidr;
> ERROR: invalid cidr value: "255.255.255.255/24"
> DETAIL: Value has bits set to right of mask.
> in this case
> ...
> has no bits set to right of
>
In PgSQL 7.4.12,
foodb=# SELECT '255.255.255.255/24'::cidr;
ERROR: invalid cidr value: "255.255.255.255/24"
DETAIL: Value has bits set to right of mask.
foodb=#
SELECT '255.255.255.255/25'::cidr;
cidr
255.255.255.255/25
(1 row)
foodb=#
in this case
.1
On Feb 22, 2006, at 18:06 , padmanabha konkodi wrote:
my query return 100 rows but if i am intrested only from 40-60 rows
then how to restrict.
for example
select * from students (returns 100 rows).but i am intrested only
rows from 40 to 60.
See LIMIT and OFFSET.
http://www.postgresql.or
padmanabha konkodi wrote:
hi all,
my query return 100 rows but if i am intrested only from 40-60 rows
then how to restrict.
for example
select * from students (returns 100 rows).but i am intrested only
rows from 40 to 60.
SELECT * FROM student ORDER BY something LIMIT 20 OFFSET 40;
Be awa
am 22.02.2006, um 9:06:57 - mailte padmanabha konkodi folgendes:
>
>
> hi all,
>
> my query return 100 rows but if i am intrested only from 40-60 rows then how
> to restrict.
>
> for example
>
> select * from students (returns 100 rows).but i am intrested only rows from
> 40 to 60.
Hi, Bond,
bond wrote:
> public Object getArray(){
> ArrayList temp = new ArrayList();
> temp.add("");
> temp.add("");
> temp.add("T");
> temp.add("Q");
> return temp.toArray();
> }
> After this i am passing this.getArray() values to database.
As a firs
hi all,
my query return 100 rows but if i am intrested only from 40-60 rows then how to restrict.
for example
select * from students (returns 100 rows).but i am intrested only rows from 40 to 60.
20 matches
Mail list logo
