Sponsored Links

mailing.database.pgsql-sql mailing.database.pgsql-sql

Page 10 of 84

Last »

Threads in Forum : mailing.database.pgsql-sql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
[SQL] Calling inner functions vs. Begin-End blocs Hi Everybody ! I'm just wondering what is really better in terms of performance ... I have a large function that makes many things, and I must... Charles N. Charotti	06-15-2011 10:40 AM Charles N. Charotti	0	16
[SQL] Select For Update and Left Outer Join This is a follow-up to an old message by Tom Lane: http://archives.postgresql.org/pgsql-sql/2006-10/msg00080.php In ORMs like NHibernate, there are... Patrick Earl	06-14-2011 08:01 PM greg.fenton	1	17
[SQL] Subselects not allowed? Can anybody tell me why this doesn't work? pgslekt=> CREATE SEQUENCE sources_source_id_seq START WITH (SELECT MAX(source_id) FROM sources); ERROR: ... Leif Biberg Kristensen	06-14-2011 09:00 AM Florian Weimer	9	13
[SQL] extract some column/value pairs via hstore In a PL/pgSQL function, I need to extract column/value pairs from a table ignoring some of the columns. The excluded column names have previously... Tarlika Elisabeth Schmitz	06-13-2011 02:04 PM Tarlika Elisabeth Schmitz	0	18
[SQL] selecting records X minutes apart ( 1 2 ) I have a table that, at a minimum, has ID and timestamp columns. Records are inserted into with random IDs and timestamps. Duplicate IDs are... lists-pgsql@useunix.net	06-12-2011 04:50 PM Gavin Flower	15	25
[SQL] Returning a set of dates Hey folks, I am still slogging away on my pet project, and I'm giving up - I need help from the experts to try to get this function working like I... C. Bensend	06-11-2011 05:18 PM C. Bensend	2	15
[SQL] ANY for Array value check Good morning, String array compare command, I forgot how to do it. E.g., create table z_drop(id varchar); insert into z_drop values('{"a1", "a2",... Emi Lu	06-11-2011 04:59 AM Jasen Betts	1	16
[SQL] need help with some aggregation magic hi, I have a log-table that stores events of users and projects like this ( user_id integer, project_id integer, ts timestamp, event_type integer... Andreas	06-09-2011 04:22 PM Edgardo Portal	6	17
[SQL] To find process that lock a table Hello , do you know how to find a process that is locking a table ? I try to run a vacuum analyze , an it take a state of waiting , I canceled it... manuel antonio ochoa	06-06-2011 06:21 PM Scott Marlowe	1	20
[SQL] 9.0+ way of determining if a LISTEN channel has a backend listening? Is there a way in post-9.0 postgres for one session to determine if a LISTEN channel currently has a backend registered to receive notifications?... James Robinson	06-01-2011 05:22 PM Greg Sabino Mullane	1	16
[SQL] problem with update data sets from front ends 8.4, Ubuntu 10.04 postgres 8.3 to 8.4 Open office base 3.2 Ubuntu 9.04 to 10.04 (new install) I recently upgraded from Ubuntu 9.04 to Ubuntu 10.04. Security and... Dean le Roux	06-01-2011 10:00 AM Dean le Roux	4	14
Re: [SQL] Re: Order of evaluation in triggers for checks on inheritedtable partitions Can procedural languages be used in rules? I didn't see any examples in the documentation that suggested something like this could be done using... Kevin Crain	05-31-2011 09:46 AM Kevin Crain	1	14
[SQL] Function to total reset a schema Hi all, I need to write a function that totally empty a schema. So I have written a TRUNCATE statement for each table and set to 0... Surfing	05-30-2011 09:45 AM Rob Sargent	4	16
[SQL] Re: Order of evaluation in triggers for checks on inherited tablepartitions On 2011-05-27, Kevin Crain <kevin.crain1 (AT) gmail (DOT) com> wrote: the problem is the check is running before the trigger. perhaps you can use a... Jasen Betts	05-30-2011 04:21 AM Jasen Betts	0	16
[SQL] Function to total reset a schema Hi all, I need to write a function that totally empty a schema. So I have written a TRUNCATE statement for each table and set to 0... Surfing	05-28-2011 09:16 AM Surfing	0	13
Re: [SQL] Re: 500KB PDF files for postgresql8.3, which is the mostefficient way? On Fri, May 27, 2011 at 9:15 AM, Emi Lu <emilu (AT) encs (DOT) concordia.ca> wrote: You asked about the "most efficient" but you didn't tell us... Samuel Gendler	05-28-2011 02:58 AM Piotr Czekalski	1	13
Re: [SQL] Order of evaluation in triggers for checks on inheritedtable partitions On Fri, 27 May 2011 12:28:51 -0700 Kevin Crain <kevin.crain1 (AT) gmail (DOT) com> wrote: Are you aware that triggers are executed in alphabetical... Tarlika Elisabeth Schmitz	05-27-2011 02:52 PM Tarlika Elisabeth Schmitz	0	15
[SQL] Order of evaluation in triggers for checks on inherited table partitions I am trying to create a trigger on updates to a table that is partitioned. The child tables are partitioned by month and include checks on a... Kevin Crain	05-27-2011 02:28 PM Kevin Crain	0	13
[SQL] Re: 500KB PDF files for postgresql8.3, which is the most efficientway? Hello, I'd like to have more comments about the following case: . tomcat6 Added more info Solution: Emi Lu	05-27-2011 11:15 AM Emi Lu	0	17
[SQL] 500KB PDF files for postgresql8.3, which is the most efficient way? Hello, I'd like to have more comments about the following case: .. 500KB per PDF file; 30 files per year ..... Emi Lu	05-27-2011 11:12 AM Emi Lu	0	16
[SQL] extracting location info from string ( 1 2 ) A column contains location information, which may contain any of the following: 1) null 2) country name (e.g. "France") 3) city name, region name... Tarlika Elisabeth Schmitz	05-26-2011 03:40 PM Tarlika Elisabeth Schmitz	15	29
[SQL] column type for pdf file ( 1 2 ) Hello, To save pdf files into postgresql8.3, what is the best column type? bytea, blob, etc? Thank you, Emi -- Emi Lu	05-26-2011 01:07 PM Ross J. Reedstrom	13	22
[SQL] enum data type vs table Hi, Are there any guidelines for deciding whether to 1) create an enum data type or 2) create a table with the set of values and then have... Seb	05-25-2011 06:08 PM Seb	2	14
Re: [SQL] Sorting Issue ( 1 2 ) Would you mind try: Select VehicleTrimAbbreviated, VehicleTrimAbbreviatedId from VehicleTrimAbbreviated Where vehicleTrimAbbreviated like... Emi Lu	05-25-2011 05:18 PM Ozer, Pam	15	26
[SQL] Performance of NOT IN and <> with PG 9.0.4 Hi, is there a reason why Not IN-performance is so poor in 9.0.4 compared to 8.4? Ty Jasmin Jasmin Dizdarevic	05-25-2011 02:49 PM Robert Haas	9	14
[SQL] Problems Pgdump I trying to get the next one : pg_dump -h 192.170.1.3 -U User --format custom --inserts --verbose --file \"/root/Desktop/$name .backup\" --table... manuel antonio ochoa	05-24-2011 09:07 PM Craig Ringer	2	18
Re: [SQL] Which version of PostgreSQL should I use. The tools "pg_dump" & "pg_restore" are used to extract and re-create databases. Can be used for chores such as deploying from development to... Basil Bourque	05-24-2011 08:56 PM Craig Ringer	5	15
[SQL] unnest in SELECT I have a couple of questions regarding unnest. 1) If I issue a select statement "select unnest(vector1) as v from some_table", I cannot seem to use... Karl Koster	05-21-2011 10:23 PM Craig Ringer	2	23
[SQL] unnest in SELECT I have a couple of questions regarding unnest. 1) If I issue a select statement "select unnest(vector1) as v from some_table", I cannot seem to use... Karl Koster	05-20-2011 02:13 PM Karl Koster	0	18
Re: SOLVED - [SQL] foreign keys and lots of tables Thanks Dave, I came up with the same answer after much googling. I managed to write a trigger to do this and it worked first time :D Then I... Gary Stainburn	05-19-2011 03:38 AM Gary Stainburn	0	19
[SQL] client-side lo_import() provided by libpq ? Hello, Postgresql8.3, tried: create table test(id, image oid); insert into test values(1, lo_import('apple.jpg')); ERROR: must be superuser to... Emi Lu	05-18-2011 09:02 PM Craig Ringer	1	16
[SQL] foreign keys and lots of tables I have the following tables (individual seat allocation removed to make it simpler) create table coaches ( -- carriages c_id serial... Gary Stainburn	05-18-2011 07:09 PM David W Noon	1	20
[SQL] self join Hi, This probably reflects my confusion with how self joins work. Suppose we have this table: =# SELECT * FROM tmp; a \| b ---+--- 1 \| 2 Seb	05-17-2011 04:07 AM Jasen Betts	6	22
[SQL] Sorting data based fields in two linked tables Hi, I am looking for a way to sort data returned from two tables with the first sort based on a field from table A and the secord sort based on the... R. Smith	05-14-2011 07:58 AM Oliver d'Azevedo Christina	1	24
[SQL] ordering by date for each ID Hi all, I have this table id \| date \| score_count ----+--------------+------------- 13 \| 1999-09-16 \| 4 13 \| 2002-06-27 \| ... Nguyen,Diep T	05-12-2011 05:18 PM Samuel Gendler	2	17
[SQL] CROSS JOIN ordering I am curious what is proper ordering for cross joining and joining at all for two tables. I look at the example... Grzegorz Szpetkowski	05-11-2011 06:19 PM Grzegorz Szpetkowski	0	20
[SQL] replace " with nothing We are converting from Oracle to Postgres. An Oracle script contains this line: select replace(firstname,'"'), memberid, emailaddress from... Tony Capobianco	05-11-2011 03:53 PM Lew	6	18
[SQL] Dates and NULL's` Hi, Maybe this is a dumb question but if I have a date field that contains a NULL will it show up when I ask for a where date range for the same date... John Fabiani	05-10-2011 12:55 PM Lew	9	21
[SQL] view table with foreign key relative values Hello List, I have searched extensively for the following question: Is it possible to view a table which has a column with a foreign key constraint... fpirotti	05-10-2011 06:49 AM fpirotti	0	19
[SQL] Trigger: update if record exists I wrote a trigger function to convert inserts into updates if the record exists already. - I am not using rules because the table is populated via... Tarlika Elisabeth Schmitz	05-09-2011 07:17 AM Tarlika Elisabeth Schmitz	0	19
[SQL] FOR EACH STATEMENT trigger ? Hi there I am trying to get an example of SET BASED trigger logic with FOR EACH STATEMENT, but I cannot find any example involving the pseudo table... F. BROUARD / SQLpro	05-09-2011 05:18 AM Pavel Stehule	2	20
[SQL] slightly OT - Using psql from Emacs with sql.el Hi, When working with psql via sql.el, multiple prompts accumulate in a single line when sending multi-line input to the SQLi buffer. For example,... Seb	05-07-2011 05:33 PM Seb	4	24
[SQL] Specifying column level collations Hi, I'm playing around with 9.1beta1 and would like to create a table where one column has a non-default collation. But whatever I try, I can't... Thomas Kellerer	05-07-2011 03:12 PM Thomas Kellerer	4	15
Re: [SQL] check constraint bug? On Thu, May 5, 2011 at 11:06 PM, Tarlika Elisabeth Schmitz <postgresql3 (AT) numerixtechnology (DOT) de> wrote: You need another level of... Scott Marlowe	05-07-2011 07:52 AM Lew	1	19
[SQL] data import via COPY, Rules + Triggers I have got a database that needs to be populated, first with historical data, then on a daily basis. Number of entities is small, data volume huge.... Tarlika Elisabeth Schmitz	05-07-2011 04:39 AM Tarlika Elisabeth Schmitz	3	18
[SQL] FOR EACH STATEMENT trigger ? Hi there I am trying to get an example of SET BASED trigger logic with FOR EACH STATEMENT, but I cannot find any example involving the pseudo table... Frédéric BROUARD	05-06-2011 12:14 PM Frédéric BROUARD	0	19
[SQL] None numeric exclusion constraints using GIST I'll give it another try. :) Is there provision for creating none numeric exclusion constraints on GIST indexes? From my reading of the following,... Richard Broersma	05-06-2011 09:57 AM Richard Broersma	0	19
[SQL] Select and merge rows? Excuse me, The original table is: order* ID* value* ---------------------- 1* 1000* 3 2* 1000* 5 3* 1000* 6 1* 1001* 1 2*... Claudio Adriano Guarracino	05-06-2011 12:41 AM Claudio Adriano Guarracino	2	20
[SQL] check constraint bug? I specified: ALTER TABLE h ADD CONSTRAINT val_h_stats CHECK (NOT (sex = 'f') AND (stats IS NOT NULL)); which was translated to: ALTER TABLE h ADD... Tarlika Elisabeth Schmitz	05-06-2011 12:06 AM Tarlika Elisabeth Schmitz	0	18
[SQL] Select and merge rows? Hello! I have a doubt about a query that I tried to do, but I cant...... This is the scenario: I have a table, with this rows: order* ID*... Claudio Adriano Guarracino	05-05-2011 03:24 PM Oliveiros	1	19

Page 10 of 84

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off