Stack Overflow
Stack Overflow

Questions tagged [postgresql-8.0]

For PostgreSQL questions specific to version 8.0.

While the generic tag should probably be used with all PostgreSQL-related questions, this tag should also be used if the question pertains to features added in version 8.0, or if the question is about a problem seen while running version 8.0.

17 questions
0
votes
1 answer

Date intervals in Postgresql not showing correct results

When running this query: SELECT start_date, end_date, extract(epoch from end_date::timestamp - start_date::timestamp)/(24*60*60) as total, extract(epoch from end_date::timestamp - GETDATE()::timestamp)/(24*60*60) as…
Henry
  • 697
  • 1
  • 6
  • 16
-3
votes
2 answers

sql Find the pattern and count how many times it appeared

Data Give 22 22 22 22 22 36 54 40 22 22 22 22 36 22 22 54 22 22 This is the column in table. Using an sql query we need to find out the pattern such as 22 36 54 40 is first pattern then 22 36 is second and 22 54 is third pattern.
Himanshu Dhingra
  • 317
  • 3
  • 7
1
2