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     
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 10: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 02: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 05: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 04: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 02: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...
07-05-2011 04:07 AM
gmb Go to last post
7 22
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 (...
06-30-2011 09: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 08: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 11:45 AM
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 02: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...
06-20-2011 10: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 ...
06-20-2011 12: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 08: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 05: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 03: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 11:49 AM
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 08: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 09: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...
06-12-2011 04: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 05: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 04: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...
06-09-2011 04: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 06: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 05: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 10:00 AM
Dean le Roux Go to last post
4 28
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 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...
05-30-2011 09: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 02: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 03: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 01: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...
05-25-2011 06: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 05: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 02:49 PM
Robert Haas Go to last post
9 23
I trying to get the next one : pg_dump -h -U User --format custom --inserts --verbose --file \"/root/Desktop/$name .backup\" --table...
manuel antonio ochoa
05-24-2011 09: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 08: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 10:23 PM
Craig Ringer Go to last post
2 58
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 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 07:09 PM
David W Noon Go to last post
1 28
Hi, This probably reflects my confusion with how self joins work. Suppose we have this table: =# SELECT * FROM tmp; a | b ---+--- 1 | 2
05-17-2011 04:07 AM
Jasen Betts Go to last post
6 35
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 Go to last post
1 32
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 Go to last post
2 37
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 Go to last post
6 31
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 Go to last post
9 32
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...
05-09-2011 05:18 AM
Pavel Stehule Go to last post
2 26
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,...
05-07-2011 05:33 PM
Seb Go to last post
4 34
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 Go to last post
4 31
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 Go to last post
1 29
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 Go to last post
3 40
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 Go to last post
2 25
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 Go to last post
1 27
Post New Thread

Display Options
Showing threads 451 to 500 of 3178
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.