Sponsored Links

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

Page 8 of 84

Last »

Threads in Forum : mailing.database.pgsql-sql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Re: [SQL] Tripping over (my own) stupidity - VARCHAR declarationminus specificity On Fri, Oct 14, 2011 at 1:27 PM, Good, Thomas <TGood (AT) svwsjmc (DOT) org> wrote: According... Adam Cornett	10-14-2011 01:28 PM Good, Thomas	3	19
[SQL] Tripping over (my own) stupidity - VARCHAR declaration minusspecificity I created a table in a hurry and forgot to specify the max capacity for a varchar() data type. Can it be said what the max would be in a case like... Good, Thomas	10-14-2011 12:27 PM Good, Thomas	0	14
Re: [SQL] 6 ..The best possible chance to finally kick the deadly habit for good. http://relaxationstation.biz/com.friend.php?igifortune=82a3 -- Sent via... HAKAN	10-14-2011 07:32 AM HAKAN	0	16
[SQL] ....This site has almost all you need! http://avto-partner.si/com.friend.php?oshowtopic=48n9 -- Sent via pgsql-sql mailing list (pgsql-sql (AT)... Theodore Petrosky	10-12-2011 12:37 AM Theodore Petrosky	0	14
[SQL] Oh! Dear! You have never been to this shop? Donâ€™t be a looser! http://the-historical-rabbi-ishmael.com/friend_invite.php?ihtopicid=1fzif -- Sent... HAKAN	10-11-2011 07:15 PM HAKAN	0	16
Re: [SQL] Extract week from date, start with sunday You can use the below query to get the week from Sunday. select ceil(((now()::date -((CAST(EXTRACT (year FROM now()) as text)\|\|'-01-04')::date -... skdangi	10-11-2011 11:19 AM skdangi	0	24
[SQL] ( 1 2 3 ) Hello all, I'm new to triggers in PostgreSQL. I have to create a trigger on insert to increment a sequence to overcome MS-Access' limitation in... tlange@gwdg.de	10-10-2011 01:31 PM HAKAN	21	406
[SQL] [GENERAL] Creating rule for sliding data Hello, I have a problem to find the good syntax for a rule for rows going for one partition to the other in cas of an update. Let me give the... F. BROUARD / SQLpro	10-09-2011 03:25 PM Guillaume Lelarge	3	26
Re: [SQL] plpgsql function executed multiple times for each return value WITH func AS ( SELECT FUNC(...) AS func_result FROM ... ) SELECT (func.func_result).* FROM func David J. David Johnston	10-08-2011 11:32 AM Tom Lane	1	13
[SQL] Edit multiple rows concurrent save Hi there! I am trying to solve a problem, but I am totally stucked. I have a database with users, cards (260) and decks. The users can have cards (a... PÃ©ter SzabÃ³	10-08-2011 04:19 AM Jasen Betts	1	12
[SQL] a spatial table's bounding box Hello,Â* My question is a basic one for postGIS, I believe. It should have a primitive answer somewhere, but I don't have it.Â* I want to get the... Asli Akarsakarya	10-04-2011 01:22 PM Asli Akarsakarya	2	10
[SQL] Edit multiple rows concurrent save Hi there! I am trying to solve a problem, but I am totally stucked. I have a database with users, cards (260) and decks. The users can have cards (a... PÃ©ter SzabÃ³	09-29-2011 04:58 PM PÃ©ter SzabÃ³	0	13
test for exist or not exists in a table and set a column based onthe test I have a query that has several outer joins and everything is working well. I need to add one additional column and table and test to see if... jkells	09-29-2011 02:35 PM jkells	0	15
[SQL] how to calculate differences of timestamps? How could I calculate differences of timestamps in a log-table? Table log ( user_id integer, login boolean, ts timestamp ) So login = true would be... Andreas	09-27-2011 11:08 AM Steve Crawford	2	17
Re: [SQL] handling duplicate row exception Hi There is no IGNORE_DUP_KEY equivalent in PostgreSQL. If you are 100% sure that you want to ignore unique key violations, you can wrap your... Filip RembiaÅ‚kowski	09-26-2011 07:57 PM Filip RembiaÅ‚kowski	2	16
[SQL] Sorting of data from two tables Greetings folks, This is a follow up to my initial message some time ago. Now I have got all the details together. I have two tables. Table A -... R. Smith	09-25-2011 01:44 PM David Johnston	3	12
[SQL] Better way to check more than 1 value NOT IN (...) Hi, I've got to check if 2 values are not in a set that is dynamically calculated by a function. The query looks like select some_id, .... from... Andreas	09-24-2011 06:54 AM pasman pasmañski	1	16
[SQL] Howto build a funtion that selects an id or inserts a value Hi, I'd like to have a function that looks up an id of an item. In case the item doesn't exist in the table yet it should be inserted and the new id... Andreas	09-23-2011 07:06 PM Andreas	0	12
[SQL] using the aggregate function max() Hi, I need a little help understanding how to attack this problem. I need to find the max(date) of a field but I need that value later in... John Fabiani	09-23-2011 01:37 AM Thomas Kellerer	3	14
[SQL] use of savepoint in containter managed transaction HI All, I have requirement to use save point. But I am using session bean whose transaction is managed by container. While executing sql insert I... Amar Dhole	09-23-2011 01:32 AM Amar Dhole	0	15
[SQL] ambiguous local variable name in 9.0 proc I've got a stored proc (which worked fine in 8.3 and 8.4) that is declared as such: CREATE OR REPLACE FUNCTION... Samuel Gendler	09-21-2011 07:00 PM Tom Lane	3	13
[SQL] Combining several CTEs with a recursive CTE Hello all, this is more a "just curious" question, rather than a real world problem. We can combine several CTEs into a single select using... Thomas Kellerer	09-20-2011 09:54 AM Thomas Kellerer	2	13
[SQL] Window function sort order help Having trouble getting a window function to sort correctly. Given this data consumer_id \| move_date \| ... Dianna Harter	09-19-2011 04:31 PM Dianna Harter	6	15
[SQL] Passing function parameters to regexp_replace I'm trying to write a sql or plpgsql function update_nametags(TEXT, TEXT) which does a replace on this form: UPDATE sources SET source_text =... Leif Biberg Kristensen	09-17-2011 01:34 PM Tim Landscheidt	4	14
[SQL] Use select and update together Hi, this is my first on this list. I can't understand where my problem in PG 8.4. CREATE TABLE tbl( KEY int, val int); Update query like: UPDATE... Boris	09-17-2011 11:16 AM Tom Lane	5	14
[SQL] insert or update within transaction Hi, http://www.postgresql.org/docs/current/static/sql-update.html has an example where an either an insert or update is done according if a key... Andreas	09-17-2011 10:49 AM Josh Kupershmidt	1	18
[SQL] Clever way to check overlapping time intervals ? Hi, is there a clever way to check overlapping time intervals ? An option named n should be taken from date y to y. The same name is ok for another... Andreas	09-16-2011 06:15 AM Frank Bax	3	17
[SQL] Partition over a sliding date window Hi, I have a simple table with 3 fields: date, value and username, which can hold identical rows. What I am trying to do is to have for each date... Guillaume Roger	09-13-2011 06:25 AM Guillaume Roger	0	17
[SQL] FW: Hi ________________________________ From: Mandana Mokhtary Sent: 10 September 2011 22:31 To: pgsql-sql-owner (AT) postgresql (DOT) org Subject:... Mandana Mokhtary	09-11-2011 08:31 PM Craig Ringer	2	17
[SQL] FW: Hi ________________________________ From: Mandana Mokhtary Sent: 10 September 2011 23:21 To: pgsql-sql-owner (AT) postgresql (DOT) org Subject: Hi Hi... Mandana Mokhtary	09-10-2011 04:22 PM Mandana Mokhtary	0	19
[SQL] Dynamic sql Hi, this is my first on this list. I want to know the basics of dynamic sql especially in PostgreSQL. I was googling for a while but have no luck... Gabriel Filipiak	09-10-2011 04:18 AM Jasen Betts	1	16
Re: [SQL] Re: how can I get the length of columns of a table by system tables/views Why not to use information schema: select column_name, character_maximum_length from information_schema.columns where table_name ='table... msi77	09-10-2011 12:51 AM msi77	0	18
[SQL] My Trigger is not working :( I think i missed some basics ... ERROR: column "ad_table_id" does not exist Where: PL/pgSQL function "oms_changelog" line 21 at... Waqar Azeem	09-09-2011 08:23 AM pasman pasmañski	1	20
[SQL] Re: how can I get the length of columns of a table by systemtables/views SELECT a.attname, pg_catalog.format_type(a.atttypid, a.atttypmod) FROM pg_catalog.pg_attribute a WHERE a.attrelid = (SELECT pg_class.oid FROM... shuaixf	09-09-2011 07:53 AM shuaixf	0	17
[SQL] How can I inherit constraints? Hi, how would I let a table inherit the constraints of its parent(s) ? It'd be rather cool not having to repeat every foreign key a table inherited... Andreas	09-06-2011 08:04 PM Andreas	0	19
[SQL] Schema partitioning Could I get feedback from the community on schema partitioning? I'm doing maintenance on my ddl and I'm noticing that my tables are all in 1 schema,... Charlie	09-02-2011 08:22 AM Little, Douglas	2	19
[SQL] Want some basic compare of data type on PostgreSQL and MySQL Hello All, I Want some basic compare of data type on PostgreSQL and MySQL. I am Try to using create the database on PostgreSQL with the same query... bhavesh1385	09-01-2011 08:45 AM Scott Marlowe	5	18
[SQL] function based index problem Hi, on table entry (17M records) there is one index: CREATE INDEX ndxlen ON uniprot_frekvencije.entry USING btree (length(sequence::text)); When... Viktor BojoviÄ‡	08-31-2011 05:17 PM Viktor BojoviÄ‡	2	13
Re: [SQL] [ADMIN] function based index problem Viktor Bojovi*<viktor.bojovic (AT) gmail (DOT) com> wrote: Because it thinks your query will return 81226 rows. We need more information to make... Kevin Grittner	08-31-2011 04:53 PM Kevin Grittner	0	16
[SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Good morning, Does psql provide something like the following query command? select * from tablename where col1 not ilike ('str1%', 'str2%'...... Emi Lu	08-31-2011 11:16 AM Pavel Stehule	9	21
[SQL] ERROR: cannot subscript type text because it is not an array I have table with field l type lseg Column \| Type \| Modifiers --------+---------+----------- cnt \| integer \| used \| boolean \| l \| lseg ... lxnf98mm@comcast.net	08-31-2011 08:26 AM lxnf98mm@comcast.net	0	19
Re: [ADMIN] [SQL] parsing audit table Hi Jamie & All I experimented a bit with the audit function and i added a field to the audit table where i store which table the audit record... Jan Eskilsson	08-28-2011 05:00 AM Jan Eskilsson	0	20
[SQL] new table with a select Hello to all, Can anybody tell me the sql instruction to create a new table with a select of other table? I need to create a new table based on... ppdcc@sapo.pt	08-26-2011 02:06 AM MIkhail Puzanov	3	20
[SQL] (pgsql8.4) DATA Corruption Happy Friday people! I was wondering if anyone had any suggestions on how to resolve this issue.... I am moving otrs to another server and during... Mikola Rose	08-25-2011 10:51 PM Craig Ringer	3	22
[SQL] Need a little help with geometric query This is my first shot at using postgresql's geometric functions I have a passel of lines defined by x1 y1 x2 y2 I created a table with type lseg and... lxnf98mm@comcast.net	08-25-2011 07:08 PM Samuel Gendler	1	21
[SQL] st_offsetcurve Hello I want to use the function st_offsetCurve but the pgadmin don't have and i don't find in the site of pgadmin. CAn anybody send... ppdcc@sapo.pt	08-25-2011 06:35 PM Brent Dombrowski	1	24
[SQL] Add one column to another I have to deal with a table which contains: first_name surname email1 email2 .... and I would like to create a view which combines both email... gvim	08-25-2011 02:46 PM vipul shah	6	20
[SQL] new table with a select Hello to all, Can anybody tell me the sql instruction to create a new table with a select of other table? I need to create a new table based on... ppdcc@sapo.pt	08-25-2011 04:35 AM ppdcc@sapo.pt	0	19
[SQL] need magic to shuffle some numbers Hi, there is a table that has among others a integer primary key "id" and another integer column "prio" as well as an integer "group_id". I'd like... Andreas	08-24-2011 09:15 AM Tim Landscheidt	2	21
[SQL] Confused about writing this stored procedure/method. Hi All, I'm trying to write a stored procedure /function to re-order a set of calendar months.I have a set of calendar months stored from January... JavaNoobie	08-24-2011 09:07 AM Tim Landscheidt	3	23

Page 8 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