Since so many people responded to my initial question, I thought I'd
post my procedural solution using PL/pgSQL (permission granted to
Roberto to acquire it).
I'm not gonna even try to explain the various references to my database
structure; there are too many. This is all from StaffOS, which
Peter, Alex,
> You can't easily build data out of nothing in a declarative way in
> SQL.
> Basically, if you want a list of data you either need to put them in
> a
> table (which you don't want) or list them in the command itself
> (which you
> can't). This isn't made easier by the fact that fun
Folks,
Thanks for your suggestions. Apparently I wasn't clear enough about
what I'm trying to do:
> >
> > SELECT ALL Wednesdays BETWEEN 5/1/01 AND 6/1/01;
> >
>
> somthing like:
>
> select date from xx where to_char(date,'fmdy') = 'wed';
This doesn't solve my problem, as th
"Josh Berkus" <[EMAIL PROTECTED]> writes:
>
> SELECT ALL Wednesdays BETWEEN 5/1/01 AND 6/1/01;
>
somthing like:
select date from xx where to_char(date,'fmdy') = 'wed';
hth,
Manuel.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comm
Folks,
Can anyone come up with a purely declarative (i.e. SQL) way to SELECT
all of the Wednesdays within a given time period? Or is there, perhaps,
some trick of the PGSQL date parser I could use?
I can think of a number of ways to do this procedurally, but that's
very awkward
