Re: [SQL] How to limit access only to certain records?

2012-06-22 Thread hari . fuchs
Andreas writes: > Hi, > > is there a way to limit access for some users only to certain records? > > e.g. there is a customer table and there are account-managers. > Could I limit account-manager #1 so that he only can access customers > only acording to a flag? Maybe something like the followin

Re: [SQL] date arithmetic with columns

2012-03-04 Thread hari . fuchs
Peter Faulks writes: > I have two columns in two distinct tables, one is the starting time of > an event, timestamp without time zone. Data is the utc datetime (for > sorting across time zones), the other is the number of minutes to add. Maybe I'm missing something, but why don't you just use ti

Re: [SQL] date range to set of dates expansion

2012-01-19 Thread hari . fuchs
Gary Stainburn writes: > Hi, > > How can I expand a date range in a table to a set of date records? > > I have a table of availabilities thus: > > Column |Type | Modifiers > ---+-+-