How select data in postgresql?

Question

I have a table as: T(Id integer,Col1 text) In table T has data:

enter image description here

I have a query is:

SELECT
  *
FROM
  T
where Col1 = '940
920
900
880
860

840
820
800
780
760

740
720
700
690
680

670
660
650
640
630

620
610
600
590
580

570
560
550
540
530

520
510
500
490
480

470
460
450
440
430

420
410
400
390
380

370
360
350
340
330'

Query doesn't return row 2. Why? can you help me? Thanks all.

It looks like you're missing whitespace in the query? Although that might be a formatting problem. Querying for such a string of numbers seems like a wrong solution for the problem though but I cannot say much about that without having more information about what you're trying to do. — Wolph
– Wolph, Commented Sep 5, 2013 at 13:13
how do you perform the query? are you sure your whitespace \n \r \t <spaces> stays intact and is not accidentally transformed? — mnagel
– mnagel, Commented Sep 5, 2013 at 13:41
If I should do something like this at my job, I would be very very sad. Do you know who designed this DB? — roman
– roman, Commented Sep 5, 2013 at 14:09

Tomas Greif · Accepted Answer · 2013-09-05 13:55:29Z

1

I'm posting this as answer only because my comment is too long. The following works in PostgreSQL so I guess it does not work for you because strings are not the same.

create table a (a varchar);

insert into a values('940
920
900
880
860

840
820
800
780
760

740
720
700
690
680

670
660
650
640
630

620
610
600
590
580

570
560
550
540
530

520
510
500
490
480

470
460
450
440
430

420
410
400
390
380');

select * from a where a = '940
920
900
880
860

840
820
800
780
760

740
720
700
690
680

670
660
650
640
630

620
610
600
590
580

570
560
550
540
530

520
510
500
490
480

470
460
450
440
430

420
410
400
390
380';

edited Sep 5, 2013 at 13:55

answered Sep 5, 2013 at 13:45

Tomas Greif

22.9k25 gold badges114 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How select data in postgresql?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related