How to write connect by query in postgres

Question

1.00/5 (1 vote)

See more:

SQL

SELECT   txtdtTrans_Date 
FROM (SELECT  1+ ROWNUM - 1 txtdtTrans_Date 
FROM dual
CONNECT BY ROWNUM <= ((TO_DATE('10/01/2021', 'dd/mm/yyyy')+1)-TO_DATE('01/01/2021', 'dd/mm/yyyy')) )

What I have tried:

above given query working in oracle sql developer but i need it in postgre sql

Posted 15-Jul-21 5:22am

chilukuri sumanth reddy

Updated 15-Jul-21 8:09am

Maciej Los

v2

Add a Solution

Comments

SeeSharp2 15-Jul-21 14:11pm

You are lazy. Why not do what Maciej did and google it? Shame shame.

chilukuri sumanth reddy 15-Jul-21 21:57pm

what i need actuly in backend 2 columns there from date and to date .

in from date 2021-05-01 and todate 2021-05-05 .

now i need output like 5 row of data

SeeSharp2 16-Jul-21 7:26am

Now you are asking for someone to do more easy work for you?

chilukuri sumanth reddy 16-Jul-21 8:36am

if u know tell me otherwise f*** off

SeeSharp2 16-Jul-21 9:07am

Lazy and rude.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2021-07-15T08:09:00

Solution 1

ROWNUM[^] in Oracle corresponds with ROW_NUMBER[^] in Postgres.

CONNET BY[^] referes to recursive cte. See: PostgreSQL: Documentation: 13: 7.8. WITH Queries (Common Table Expressions)[^]

To add 1 day to specific date, use: '2021-07-15' + interval '1 day'

The rest belongs to you!

Posted 15-Jul-21 8:09am

Maciej Los