uot; in column "col" so the !~~* should return 99 rows. ??
Wild guess:
select count (*) from table where col is null;
count
------
1
(1 row)
";-)
Reinoud
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen
row.
Still, you could normalize the data in a better way, and present it to
users or an application with views or stored procedures...
Reinoud
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwenreinou...@n.leeuwen.
_
"Nothing is as subjective as reality"
Reinoud van Leeuwenreinou...@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.pos
t datamodel?
Reinoud
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwenreinou...@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To ma
e.
>
> Please provide me with some guidelines. Ask me any queries.
this smells like DNS resolving...
Reinoud
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwenreinou...@n.leeu
rting mechanism. psql shell command for such report will be just fine.
pg_dump?
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwenreinou...@n.leeuwen.net
http://reino
ble does not have to be read at all).
Reinoud
--
______
"Nothing is as subjective as reality"
Reinoud van Leeuwenreinou...@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__
--
Sent via pgsql-sql mailing list (pgsql-
gt; What can I do to improve the performance?
Have you tried 'select count (1)..."?
Reinoud
--
______________
"Nothing is as subjective as reality"
Reinoud van Leeuwenreinou...@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
server or the client? This sounds like a client
issue to me..
Reinoud
--
______________
"Nothing is as subjective as reality"
Reinoud van Leeuwenreinou...@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__
--
Sent via pgsql-sql m
ng is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
(some errors might not have entries on some dates)
Has somebody ever made a generic solution for something like this? (or do
I need a reporting tool?)
Thanks in advance,
Reinoud
--
__
"Nothing is as subjective as reality"
Reinoud v
o account? (and wich ones?)
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TIP 1: if posting/rea
database in the same order. Alphabetically is easiest to remember...
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---
t test if some records exist. They allways do, so
the where clause evaluates to true for every row
--
______________
"Nothing is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reino
does not contain any column
to sort on. So I think it will evaluate to some constant value and not
sorting is really done
--
______
"Nothing is as subjective as reality"
Reinoud van Le
___________
"Nothing is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TI
7;C'
>
> Is there a more efficient SQL statement that accomplishes the same limiting
> functionality?
I do not know wheter it is more efficient in terms of execution, but I can
read this more efficiently:
WHERE column1 in ('A', 'B', 'C')
--
_______
rigger that sets the uniqueness column to 0 when the active
column equals 'y'. This will result in:
- unique num columns (or the index will fail) where active = 'y'
- arbitrary num colums (index will always be unique) where active = 'n'
--
an operator '=' for types 'character' and
> 'boolean' You will have to retype this query using an explicit cast.
can you post the output of '\d lu_dewey'?
--
__
"Nothing is as
e IS operator:
where field IS null
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TIP 7:
file)? Without destroying existing
> entries, of course...
insert into desttable (col1, col2, col3)
select col1, col2, col3 from sourcetable
where somecol = somevalue;
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuw
t_id),
object_subobject_def_fk btree (subobject_def_id)
Triggers: tdb_object,
tiua_object,
tiub_object
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
need a tool like this
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen [EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-no
Sybase Powerdesigner. You can read the Sybase
definition, and create a Postgresql definition from there. An
evaluation version (fully functional for a limited time) is
downloadable from the Sybase website
--
______________
"Nothing is a
unctions-formatting.html
and
http://www.postgresql.bit.nl/devel-corner/docs/user/functions-datetime.html
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen [EMA
Is something like this posstible in PostgreSQL?
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen [EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
26 matches
Mail list logo
