| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hello postgresql users,
I have a question regarding building a tsearch2 query that does wildcard
searching by default. Currently, I am using...
Anders Østergaard Jensen
|
08-08-2010 10:51 AM
Tom Lane  | 1 | 10 |
| | | Hello,
I have just installed version 8.4 of PostGresql (on a Windows machine)
in order to use SKYLINE command, but it seems that I get an error...
LaboRecherche
|
08-08-2010 08:40 AM
Yeb Havinga | 2 | 8 |
| | | Hi!
Is there a way to use output parameters with a pl/python fucntion?
I've tried with no luck: if I define out parameters, it says return type
must...
Imre Horvath
|
08-07-2010 03:22 PM
Tom Lane | 2 | 6 |
| | | Hello,
here my two pence on this recurring thema.
(just a workaround)
Marc Mamin
|
08-06-2010 07:19 AM
Marc Mamin | 1 | 8 |
| | | On Wed, Aug 4, 2010 at 1:25 PM, Little, Douglas
<DOUGLAS.LITTLE (AT) orbitz (DOT) com>wrote:
I've found complex and simple rules pretty hard to...
Richard Broersma
|
08-04-2010 04:52 PM
Richard Broersma | 0 | 7 |
| | | How does PostgreSQL react to time being stepped at bootup? My Chrony
NTP package might cause it to do so on rare occasions when the hardware
clock...
John Hasler
|
08-04-2010 04:33 PM
Frank Bax | 5 | 6 |
| | | On 08/04/2010 12:35 PM, Marc Mamin wrote:
I don't understand what you mean by missing ROWNUM feature, PG got this
with windows-functions in...
Andreas Joseph Krogh
|
08-04-2010 03:07 PM
Andreas Joseph Krogh | 0 | 7 |
| | | I am using Postgres 8.4 with 10 partition tables. We'll call them
reports_00 through reports_09.
I have a field that is a BIGINT which is a 13...
Joshua Gooding
|
08-04-2010 09:43 AM
Kenneth Marshall | 1 | 7 |
| | | Hi,
I need to display log events (again).
The log is simply like this
log ( log_id serial primary key, create_ts timestamp default
localtimestamp,...
Andreas
|
08-04-2010 06:48 AM
A. Kretschmer | 1 | 8 |
| | | I would like to take several rows from a select and have them grouped
into one row with the text contents of one field in all the rows
concatenated...
John Gage
|
08-03-2010 03:35 PM
Alvaro Herrera | 1 | 8 |
| | | We recently upgraded from 8.3 to 8.4 and are noticing a change in
behavior that we can't seem to associate with a particular server
setting.
In...
Garrett Murphy
|
08-03-2010 10:54 AM
Tom Lane | 1 | 5 |
| | | I am trying to make aggregate function of existing function which looks like
this.
CREATE OR REPLACE FUNCTION "grafika"."pov_sphere" (x numeric, y...
Viktor Bojović
|
08-03-2010 09:48 AM
Tom Lane | 1 | 7 |
 | | Hi,
having a table similar to
a simple group by gives me:
What I want to get is the values grouped by "subset", where a subset is a set of rows...
Rainer Stengele
|
07-31-2010 02:48 PM
Rainer Stengele | 15 | 16 |
| | | Dear All,
How can i retrieve only spatial enabled tables form the
database(Postgresql/PostGIS).Please let me know.
I am waiting for your great...
venkat
|
07-29-2010 11:27 PM
venkat | 1 | 5 |
| | | I'm trying to do this:
select * from table where field::text ilike '%\_%';
but it doesn't work.
How do you escape the _ and $ chars?
The docs say...
Wes James
|
07-29-2010 02:16 AM
Thomas Kellerer | 7 | 8 |
| | | Hey Dmitriy,
thanks for your reply.
I've played the whole weekend with the rule-system, but it didn't work
for my case. I have a dynamic trigger,...
Torsten Zühlsdorff
|
07-28-2010 01:45 AM
Torsten Zühlsdorff | 1 | 5 |
| | | =?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= <foo (AT) meisterderspiele (DOT) de> writes:
Why in the world would you do that? Just return the modified...
Tom Lane
|
07-27-2010 03:50 PM
Tom Lane | 0 | 4 |
| | | HI everyone,
Im new here, this is my first mail and i would like to know how return from
a query only alphanumeric values and these symbols:...
Enrique Palacios
|
07-26-2010 10:44 AM
Osvaldo Kussama | 1 | 4 |
| | | Hi,
is there a way to delete from a table using information from another
table to decide if a row should be dropped?
In my case there is a...
Andreas
|
07-24-2010 06:47 AM
Joshua Tolley | 1 | 4 |
| | | Hey Andreas,
You may want to use the USING clause:
DELETE FROM events USING event_types
WHERE events.event_type_fk = event_types.event_type.id
AND...
Dmitriy Igrishin
|
07-24-2010 04:22 AM
Dmitriy Igrishin | 0 | 4 |
| | | Hello,
i have a non-trival problem and i do not believe that it is solvable.
I have defined an BEFORE UPDATE trigger. The trigger catch every...
Torsten Zühlsdorff
|
07-23-2010 07:53 AM
Torsten Zühlsdorff | 0 | 4 |
| | | I have PostgreSQL 8.3.9
and the custom first and last aggregates...
Wes Devauld
|
07-22-2010 02:24 PM
Richard Huxton | 4 | 5 |
| | | Hi All,
I have a column in my Postgresql database tables which need UUID.
Is there any function in Pgsql for UUID generation. Please help me in...
Trinath Somanchi
|
07-21-2010 07:38 AM
Kenneth Marshall | 3 | 5 |
| | | Hi,
I currently have a simple queue written ontop of Postgres. Jobs are
inserted and workers periodically check for jobs they can do, do them,
and...
Brett Hoerner
|
07-20-2010 03:33 PM
Rob Sargent | 1 | 7 |
| | | Hey all,
For example, when using libpq(-xx), it is possible to get the oid of the
type of any column.
Is there a guarantee that oids of base types...
Dmitriy Igrishin
|
07-19-2010 06:04 AM
Peter Eisentraut | 1 | 9 |
| | | On Wed, Jul 14, 2010 at 09:58:10PM +1000, Anders ??stergaard Jensen wrote:
Have you tried 'select count...
Reinoud van Leeuwen
|
07-15-2010 04:16 AM
REISS Thomas DSIC BIP | 7 | 9 |
| | | I want to subtract to dates to know the number of days different.
Example:
01/02/2010 - 01/01/2010 = 1 day
08/01/2010 - 07/31/2010 = 1 day
Campbell, Lance
|
07-15-2010 02:18 AM
Thomas Kellerer | 7 | 22 |
| | | 2010/7/10 Andreas <maps.on (AT) gmx (DOT) net>:
you can use enums, you can use a hstore contrib module, but what you
doing is best
regards
Pavel...
Pavel Stehule
|
07-10-2010 04:02 AM
Pavel Stehule | 0 | 1,058 |
| | | Hi
how would I store little key-Nr to text lists?
Like e.g.
colors
1 red
2 green
3 blue
Andreas
|
07-10-2010 02:57 AM
Andreas | 0 | 184 |
| | | Two rrror codes are interesting for this:
42000 SYNTAX ERROR OR ACCESS RULE VIOLATION
42601 SYNTAX ERROR
"Davor J." <DavorJ (AT) live (DOT) com>...
Davor J.
|
07-09-2010 02:52 AM
Davor J. | 0 | 162 |
| | | Srikanth Kata wrote on 02.07.2010 14:24:
What about the answers you got...
Thomas Kellerer
|
07-08-2010 05:08 PM
Thomas Kellerer | 0 | 137 |
| | | Hey all,
Is there a way to add constraint to the domain that used by a composite type
that used by a table? E.g.:
CREATE DOMAIN superid AS...
Dmitriy Igrishin
|
07-08-2010 02:41 PM
Vibhor Kumar | 1 | 168 |
| | | I am the only developer, DBA etc.. for a small project. Today (yesterday was
everything was perfect) many of the sequence numbers fell behind what...
John
|
07-08-2010 09:57 AM
Torsten Zühlsdorff | 10 | 242 |
| | | Hi all,
Is there any sort of pattern matching or partial matching capability
in tsearch2?
I'd like to be able search for a common prefix (like for...
Peter Koczan
|
07-07-2010 08:51 PM
Peter Koczan | 2 | 158 |
| | | Hi,
is there a way to find events in a log that happen within a certain
timespan to each other?
Log is like this
event_id integer not null...
Andreas
|
07-07-2010 05:01 PM
Tim Landscheidt | 1 | 115 |
| | | Dear Sreelatha.
It is working fine. Thanks alot.
Thanks and Regards,
Venkat
On Wed, Jul 7, 2010 at 3:42 PM, Sreelatha G <sreetlatha (AT) gmail...
venkat
|
07-07-2010 05:12 AM
Sreelatha G | 1 | 148 |
| | | Dear All,
How to get Column Names from Table in PostgreSQL.
Thanks and Regards,
Venkat
venkat
|
07-07-2010 04:17 AM
venkat | 3 | 147 |
| | | And what I really like about it is the way you can make a guess about the
table name and use * .
postgres-# \d mt*
Table "public.mt1"
Column | Type...
Jayadevan M
|
07-07-2010 04:13 AM
AI Rumman | 1 | 153 |
| | | I'm in the need of a way to determine the disk size of a table that
excludes dead tuples. Here is my situation. Our company would like to
provide a...
Brian Helm
|
07-06-2010 02:42 PM
Brian Helm | 0 | 128 |
| | | Hi,
How can I store Byte strings into a postgresql database.
Is there any special command to store it. How will be the sql query.
I have gone...
Trinath Somanchi
|
07-05-2010 01:45 AM
Sergey Konoplev | 1 | 151 |
| | | Hey all,
Is there are way to create domain based on a composite type?
Regards,
Dmitriy
Dmitriy Igrishin
|
07-02-2010 04:15 AM
Dmitriy Igrishin | 0 | 172 |
| | | I'm not quite sure how to ask for the query I want, so let's start with
data:
create table t1 (i int, val varchar);
insert into t1 values(1,'A B C...
Frank Bax
|
07-02-2010 04:02 AM
silly sad | 7 | 189 |
| | | LinkedIn
------------Eduardo Schweigert requested to add you as a connection on LinkedIn:
------------------------------------------
Marcin,
I'd...
Eduardo Schweigert
|
06-30-2010 01:28 PM
Eduardo Schweigert | 0 | 147 |
| | | LinkedIn
------------Eduardo Schweigert requested to add you as a connection on LinkedIn:
------------------------------------------
Marcin,
I'd...
Eduardo Schweigert
|
06-30-2010 12:13 PM
Eduardo Schweigert | 0 | 145 |
| | | Dear members,
My table consist off the following fields
CREATE TABLE test
(
id bigserial NOT NULL,
name character varying(100),
Jerrel Kemper
|
06-30-2010 03:12 AM
silly sad | 3 | 167 |
| | | Dear members of the list.
I've tried to summarise my problem in a synthetic manner.
Stripping non necessary columns (they only contain data about the...
ced
|
06-28-2010 09:22 AM
ced | 6 | 175 |
| | | Hi,
I have a table in which the data's are entered like,
Example:
One (1)
Two (2)
Three (3)
Nicholas I
|
06-28-2010 01:46 AM
Marcin Krawczyk | 3 | 183 |
| | | On 06/26/10 17:09, wrote:
IT IS REALLY SAD !
the round(Numeric) does not behave as Math science prescribes :(
Shame on PostgresQL !
--
Sent via...
silly sad
|
06-28-2010 12:29 AM
silly sad | 0 | 164 |
| | | Is it documented anywhere that floating-point numbers round
"scientifically", that is 0.5 rounds to the nearest even number? Compare:
SELECT...
Lee Hachadoorian
|
06-26-2010 08:18 AM
Jasen Betts | 6 | 167 |
| | | I have an script with many "\copy" commands. For example:
\copy privilegios from...
bruno.scovoli
|
06-25-2010 08:51 PM
Adrian Klaver | 2 | 143 |
