View - Join based on dis-similar data types

Поиск
Список
Период
Сортировка
От speakeasy
Тема View - Join based on dis-similar data types
Дата
Msg-id gdacnSAwcOe6yvujXTWcoA@speakeasy.net
обсуждение исходный текст
Ответы Re: View - Join based on dis-similar data types  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
I have a field defined as a character(50) data type, and the same field
stored in a transition table as a text type.

The view itself work based on the join, however sub-queries against the view
on that field do not return any data.

Example:

Table1
----
T1Data - Character(50)


Table2
----
T2Data - Text


View1:
---
SELECT T1Data from Table1 JOIN Table2 ON (Table1.T1Data = Table2.T2Data);


A select against View1
SELECT * FROM View1 returns all relevant records, however, adding a WHERE
clause produces no output.

Please advise.





В списке pgsql-sql по дате отправления:

Предыдущее
От: Ninonard Policarpio
Дата:
Сообщение: postgresql installation question
Следующее
От: Kim Petersen
Дата:
Сообщение: Re: problematic query (for me ;-) [solved? - sorry to bother]