dbTalk Databases Forums  

Sponsored Links


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


Discuss in the mailing.database.pgsql-sql forum.



Post New Thread
Threads in Forum : mailing.database.pgsql-sql Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hi all, Note: I'm happy to read howtos, tutorials, archived messages - I just haven't found anything that addresses this yet. I found a related...
Don Parris
08-11-2011 05:21 PM
Don Parris Go to last post
3 33
Strange... Tables have hidden columns but AFAIK, "name" is not one of...
Oliveiros d'Azevedo Cristina
08-09-2011 12:04 PM
Tom Lane Go to last post
2 29
Hi! I have strange issue with nested left-joins in postgresql... It's hard to explain, but easy to show =) here we are:
ai
08-08-2011 03:14 PM
Carla Go to last post
3 32
Hi, Can you point me to any pages that explain the difference between using, say CHAR(8) vs VARCHAR(8) as the primary key for a table? Is there...
Raj Mathur
08-05-2011 08:43 AM
Jasen Betts Go to last post
4 24
Hi, Is there any built-in function/add-on module available in PostgreSQL, that converts a given "timestamp"/"timestamptz" value into its relative...
Gnanakumar
08-05-2011 05:07 AM
Gnanakumar Go to last post
5 26
select count(*) from table; count ------- 100 (1 row) is correct
Wes James
08-02-2011 10:13 AM
Wes James Go to last post
4 24
Hi, I just noticed that to_char() will "accept" invalid dates such as 2011-02-31 and "adjust" them accordingly: postgres=> select...
Thomas Kellerer
07-29-2011 01:48 PM
THOMPSON, JARED Go to last post
8 34
I have the following query Select PubArticleId, PubArticlePageXML from PubarticlePageXml x Inner Join Pubarticlepage p on...
Ozer, Pam
07-21-2011 07:28 PM
Ozer, Pam Go to last post
1 31
Hi, in postgreSQL (with LTREE extension) database I have the following table "comments": id BIGINT /* id */ article_id BIGINT /*article-id...
Ivan Polak
07-21-2011 01:31 PM
Ivan Polak Go to last post
7 29
Hi I would like to build Postgres from source with the visual studio 2010 compiler Is it supported? Is there any document which describes the...
Sofer, Yuval
07-20-2011 10:39 AM
Kevin Crain Go to last post
1 28
Hello, I've been trying to find out how to find out which sql was run to create a certain table. As I need this in a program which may access...
B.Rathmann
07-14-2011 07:40 PM
Craig Ringer Go to last post
5 32
Hi, I'm using postgresql 9 and I'd like to know if there is a way to "ask" if when I'm going to add a column, I'm exceeding the max number of...
Miguel Angel Conte
07-13-2011 02:20 PM
Kevin Crain Go to last post
18 34
I'm using Erlang and postgresql to build a web interface. When I create the query string I get something like: select * from table where...
Wes James
07-13-2011 11:36 AM
Wes James Go to last post
2 23
Jose Ig Mendez, 13.07.2011 09:36: Just leave out the quotes: select * from myTable where id_integer IN (1,2,3,4) --
Thomas Kellerer
07-13-2011 03:50 AM
Pavel Stehule Go to last post
1 23
Hi, I'm starting up a datawarehouse with patitioning. my etl processes write directly into the corresponding partitions instead of using...
Uwe Bartels
07-10-2011 06:48 PM
Gavin Flower Go to last post
7 28
hi all, can you tell me what is similar to like operator in mysql for postgresql hatem gamal -- Sent via pgsql-sql mailing list (pgsql-sql (AT)...
hatem gamal elzanaty
07-10-2011 05:11 PM
Scott Marlowe Go to last post
1 23
This is a little hard to explain, and I'm not sure if it's possible, but here goes. This is my query: select year, month, (select number from...
M. D.
07-06-2011 03:04 AM
Samuel Gendler Go to last post
1 26
Hi I have a stored function returning a record consisting of two field, and receiving as input a single identifier: CREATE FUNCTION calcvalues(IN...
gmb
07-05-2011 05:07 AM
gmb Go to last post
7 23
Hi, how can I remove a set of characters in text-columns ? Say I'd like to remove { } ( ) ' " , ; . : ! Of course I can chain replace ( replace (...
Andreas
06-30-2011 10:43 PM
Andreas Go to last post
3 23
what is the best performance / best practices for frequently-used simple dml, for example, an insert 1. fast-interface 2. prepared statement calling...
chester c young
06-27-2011 09:40 AM
Pavel Stehule Go to last post
7 24
Hi, I have a SELECT statement that is using the regexp_split_to_table function as follows: .... and fk_topic in (select...
John Fabiani
06-23-2011 12:45 PM
John Fabiani Go to last post
1 28
the database collation is: en_US.UTF-8 drop table t1; create table t1 (recid int ,f1 varchar(20)); insert into t1 values (1,'a'); insert into t1...
Eyal Wilde
06-23-2011 03:18 AM
Pavel Stehule Go to last post
15 38
Hi, I've got a table with a couple of objects. Primary key object_id. There is a function that fetches some values from another table that relate...
Andreas
06-20-2011 11:56 PM
Pavel Stehule Go to last post
1 22
Hi, I am totally new to PostgreSQL and this is my first script. Can anyone please help me with my following requirement I have script that returns ...
Tripura
06-20-2011 01:05 PM
Ross J. Reedstrom Go to last post
4 27
hi, please see this code select aiah_number.aiah_number_id, aiah_number.aiah_number, lock.lock_status, rank.rank_value, approve.approve_status,...
hatem gamal elzanaty
06-20-2011 09:29 AM
Emi Lu Go to last post
2 19
Hi, I am new to postgre sql.I need to convert sqlite datbase to postgres database.i have nearly 15 table in my sqlite database in which 3 table...
sara vanan
06-16-2011 06:08 PM
Viktor Bojović Go to last post
1 33
I have a fact table that looks like this: dim1_fk bigint, time_fk bigint, tstamp timestamp without timezone value numeric(16,2) The tstamp column...
Samuel Gendler
06-15-2011 04:52 PM
Samuel Gendler Go to last post
1 21
Hi! Although I try for some time, I am not able to write an SQL-Query that can do the following: I have a very big table (let's call it "mytable")...
Jira, Marcel
06-15-2011 12:49 PM
Oliveiros d'Azevedo Cristina Go to last post
3 21
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 09:01 PM
greg.fenton Go to last post
1 37
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 10:00 AM
Florian Weimer Go to last post
9 21
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 05:50 PM
Gavin Flower Go to last post
15 34
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 06:18 PM
C. Bensend Go to last post
2 22
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 05:59 AM
Jasen Betts Go to last post
1 25
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 05:22 PM
Edgardo Portal Go to last post
6 22
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 07:21 PM
Scott Marlowe Go to last post
1 26
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 06:22 PM
Greg Sabino Mullane Go to last post
1 24
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 11:00 AM
Dean le Roux Go to last post
4 29
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 10:46 AM
Kevin Crain Go to last post
1 23
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 10:45 AM
Rob Sargent Go to last post
4 23
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 03:58 AM
Piotr Czekalski Go to last post
1 20
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 04:40 PM
Tarlika Elisabeth Schmitz Go to last post
15 39
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 02:07 PM
Ross J. Reedstrom Go to last post
13 31
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 07:08 PM
Seb Go to last post
2 25
Would you mind try: Select VehicleTrimAbbreviated, VehicleTrimAbbreviatedId from VehicleTrimAbbreviated Where vehicleTrimAbbreviated like...
Emi Lu
05-25-2011 06:18 PM
Ozer, Pam Go to last post
15 46
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 03:49 PM
Robert Haas Go to last post
9 23
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 10:07 PM
Craig Ringer Go to last post
2 24
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 09:56 PM
Craig Ringer Go to last post
5 24
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 11:23 PM
Craig Ringer Go to last post
2 67
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 10:02 PM
Craig Ringer Go to last post
1 34
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 08:09 PM
David W Noon Go to last post
1 28
Post New Thread

Display Options
Showing threads 451 to 500 of 3190
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.