Re: [SQL] ORDER BY with LTREE

2006-02-19 Thread Michael Fuhr
On Fri, Feb 17, 2006 at 02:28:13PM +, Axel Straschil wrote: > Im working with the ltree [1] datatype and have labels that can not used > directly in ltree and a want to get a tree like strukture ordered by the > labels. Are you saying that you can't convert labels into ltree values like 'c.a'

Re: [SQL] Given 02-01-2006 to 02-28-2006, output all days.

2006-02-19 Thread Michael Fuhr
On Sun, Feb 19, 2006 at 01:47:21PM -0500, Henry Ortega wrote: > I was able to find a suitable 7.3.2 plpgsql.so and now plpgsql works. > (supposedly) > > I am trying out some really basic function creation such as this: > > create function dng2(start_date DATE) returns setof date as $$ > declare >

Re: [SQL] Given 02-01-2006 to 02-28-2006, output all days.

2006-02-19 Thread Stephan Szabo
On Sun, 19 Feb 2006, Henry Ortega wrote: > I was able to find a suitable 7.3.2 plpgsql.so and now plpgsql works. > (supposedly) > > I am trying out some really basic function creation such as this: > > create function dng2(start_date DATE) returns setof date as $$ > declare > aa date:=start_date;

Re: [SQL] Given 02-01-2006 to 02-28-2006, output all days.

2006-02-19 Thread Henry Ortega
I was able to find a suitable 7.3.2 plpgsql.so and now plpgsql works. (supposedly)I am trying out some really basic function creation such as this:create function dng2(start_date DATE) returns setof date as $$ declareaa date:=start_date;But I always get thisERROR:  parser: parse error at or near "D

Re: [SQL] Need help: Find dirty rows, Update, Delete SQL

2006-02-19 Thread Janning Vygen
Am Samstag, 18. Februar 2006 18:41 schrieb [EMAIL PROTECTED]: > Hello, > > I need a bit of help with some SQL. > I have two tables, call them Page and Bookmark. > Each row in Page can have many Bookmarks pointing to it, and > they are joined via a FK (Page.id = Bookmark.page_id). > > Page has a 'ur